•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I create a formula that sums values if another column matches a condition (job = attorney)?
Our take
To create a formula that sums values based on a matching condition, such as filtering for individuals with the job title "attorney," you can use the `SUMIF` function in your spreadsheet. This function allows you to specify a condition to evaluate—like checking if the job equals "attorney"—and then sum the corresponding donations. By applying this formula, you can easily calculate the total donations made by attorneys, enhancing your data analysis and ensuring you focus on the insights that matter most.
Trying this again with a new title because my post got removed. I have a spreadsheet with individuals, their jobs, and certain donations they've made. I only want to filter it out by job, like for example "If job = attorney, then put donation in different column" so that it eventually adds up the total amount of donations from attorneys. How would I do this? Example table below.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#financial modeling with spreadsheets#rows.com#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#Excel alternatives#spreadsheet API integration#AI formula generation techniques#formula generator