New Contributor

# 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
3 Replies

# Re: formula

@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.

# Re: formula

The formula in G2 (and copied down) is:

=SUMIFS(\$C\$2:\$C\$18, \$A\$2:\$A\$18, E2 & "*", \$B\$2:\$B\$18, F2)

# Re: formula

thank you, this helps me tremendously!