L. Howard Kittle wrote:
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)

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