All,

I am trying to find a way to condense this formula:

=SUMIF(CSSummary!$2:$2,$C6,CSSummary!$15:$15)+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$24:$24)+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$35:$35)+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$62:$62)

I have used the SUMPRODUCT function to capture multiple rows before but cannot find an answer on the net or remember how to do it.

My question is, how can I condense my formula so that I don't have to continue adding another "sumif" statement to the formula for each new row I want to capture?

Here is an easier way to look at the formula I have placed above:
SUMIF(CSSummary!$2:$2,$C6,CSSummary!$15:$15)
+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$24:$24)
+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$35:$35)
+SUMIF(CSSummary!$2:$2,$C6,CSSummary!$62:$62)

Any help is greatly appreciated.