How to condense my extra long SUMIF formula?

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.

Please Login or Register  to view this content.

Thanks ben_hensel.

For some reason this doesn't work for me.
The plus operator doesn't seem to work for me to add the separate rows. I tried using a comma instead and I get some astronomical number that doesn't make sense for my data? Any thoughts?

Try it this way:

Please Login or Register  to view this content.

Let me know if you have any questions.

Originally Posted by The Exceller

For some reason this doesn't work for me.
The plus operator doesn't seem to work for me to add the separate rows. I tried using a comma instead and I get some astronomical number that doesn't make sense for my data? Any thoughts?

(1) Doesn't work how? Throwing an error code? Or just not an expected value?
If possible post the spreadsheet so I can diagnose.

(2)...well the function is called SUMPRODUCT, that means it takes the SUM of the PRODUCT at each index of the arrays. So it's a huge number because it's taking the product instead of the sum across the rows.

Anyway, JeteMc has a sightly different formulation that should (also) work.