Basically, what I want to do is search for a specific entity code that may be in multiple rows, and if any of those rows contain one of three specific account codes, I want to take the sum. For example:
Entity Code Account Code Amount
1 20 100
1 25 220
1 40 160
1 50 70
1 60 95
1 70 110
2 30 100
2 25 220
2 55 160
2 50 70
2 65 95
2 70 110
This is just a quick example I put together since I'm not the best at copying and pasting pictures of my actual spreadsheet. What I want to do is search for the entity, and if any of the account codes match 20, 50 or 60, I want it to take the number from the amount column and sum them. So for entity 1, the total would be 265 (100+70+95) since it contains all of the accounts. Entity 2 would be 70 since it does not contain account code 20 or 60, just 50.
I hope this makes sense. I thought a SUMIF would do the trick, but I can't seem to get that to work. Please let me know if you have any questions or require any additional information.
Thanks!
Bookmarks