SumIf - Multiple Cells Q

[Sundance_Kid]

Hi Folks

I am trying to sumup multiple columns in a range depending on criteria. but having an issue.

Normal formula if just looking to sumup the numbers in one column would be something like this, with the criteria being cell X11 =SUMIF(A1:A10,X11,C1:C10)

Now I want to sumup multiple columns, so I want to sum up from C1: E10 but the range (A1:A10) and the criteria (X11) stays the same. I will be dragging the formula down for around 10 rows.

SUMIF(A1:A10,X11,C1:E10) does not seem to work

Any idea how I can do that?

Thanks

 

[KRice]

You could try:
=SUMPRODUCT((A1:A10=X11)*(C1:E10))

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)