1 min readfrom 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)?

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.

https://preview.redd.it/bdpln0tx17yg1.png?width=638&format=png&auto=webp&s=fe66652628f0626c619fcad037890e2cd73285c2

submitted by /u/BrandinoBranflakes
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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