Only adding up specific categories

A

affiliateian

I was wondering if there is a simple way to do this.

1. Column A & B are both categories so for example Office Cleaning
could be in either columns
2. Column C are the associated dollar values
3. Only add up cells in Column C is "Office Cleaning" is either in
Column A or B

Is this possible?
 
A

affiliateian

I am able to get SUMIF to work if all my data is in a column with no
blank. Can't get it to work with blanks in some rows. Any ideas?
 
L

L. Howard Kittle

See if this works for you. Where "xxx" is Office cleaning. You can use a
cell reference instead of "xxx" also.

=SUMIF(A2:A10,"xxx",C2:C10)+SUMIF(B2:B10,"xxx",C2:C10)

HTH
Regards,
Howard
 
A

affiliateian

L. Howard Kittle said:
See if this works for you. Where "xxx" is Office cleaning. You can use a
cell reference instead of "xxx" also.

=SUMIF(A2:A10,"xxx",C2:C10)+SUMIF(B2:B10,"xxx",C2:C10)
Click to expand...

Ahhh, breaking eash SUMIF up. ok, that works! Thanks so much.
 
Top