Forum Discussion
formula
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 |
The formula in G2 (and copied down) is:
=SUMIFS($C$2:$C$18, $A$2:$A$18, E2 & "*", $B$2:$B$18, F2)
- thank you, this helps me tremendously!
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.
