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