Oct 18 2022 07:37 AM
hi
I need a formula please. I need to find the sum of all compensation for each the of first column...like add all of compensation for 4 regardless of letter, so compensation is 406000. I tried to post in the community, but it won't let me
3a | Compensation-Budget | 0 |
3a | Sundry - Budget | 13000 |
3a | Supplies - Budget | 2000 |
3b | Compensation-Budget | 0 |
3c | Compensation-Budget | 405000 |
3c | Sundry - Budget | 13000 |
3c | Supplies - Budget | 2000 |
4a | Compensation-Budget | 0 |
4a | Sundry - Budget | 0 |
4b | Compensation-Budget | 252000 |
4b | Sundry - Budget | 11000 |
4b | Supplies - Budget | 3000 |
4c | Compensation-Budget | 154000 |
4c | Sundry - Budget | 10000 |
5a | Compensation-Budget | 561000 |
5a | Sundry - Budget | 34000 |
5a | Supplies - Budget | 5000 |
Oct 20 2022 09:35 AM
@Sheila590 I'm not sure what you mean by trying to post in the community but that it wouldn't let you. Did you try to post to the Excel discussion space?
I'm going to move this to the Excel discussion space as the space you've posted is intended for discussion around the Microsoft Tech Community website only. Please let us know if you have any issues posting in the Excel discussion space in the future as we'd be happy to troubleshoot for you.
Oct 20 2022 10:21 AM
The formula in G2 (and copied down) is:
=SUMIFS($C$2:$C$18, $A$2:$A$18, E2 & "*", $B$2:$B$18, F2)