Sumif for multiple conditions

Do anyone know if it is possible to do a sumif function for more than one
condition? What I want to do is sum the items in column C that meet the
criteria of column A = "ABC" and column B = "XYZ"

Can anyone help?

Thanks in advance

One way

=SUMPRODUCT(--(A2:A5000="ABC"),--(B2:B5000="XYZ"),C2:C5000)


will do what you want, note that you need to specify the range sizes and
they need to have the same dimensions
in this setup. Also a good policy would be to replace the hardcoded "ABC"
and "XYZ" with cells where instead of changing the formula itself you only
need to change the criteria in those cells

--


Regards,


Peo Sjoblom

"DMcCormack" wrote in message
...
Do anyone know if it is possible to do a sumif function for more than one
condition? What I want to do is sum the items in column C that meet the
criteria of column A = "ABC" and column B = "XYZ"

Can anyone help?

Thanks in advance

You can do it this way:

=SUMPRODUCT((A1:A100="ABC")*(B1:B100="XYZ")*(C1:C1 00))

Hope this helps.

Pete

On Sep 23, 4:14*pm, DMcCormack
wrote:
Do anyone know if it is possible to do a sumif function for more than one
condition? What I want to do is sum the items in column C that meet the
criteria of column A = "ABC" and column B = "XYZ"

Can anyone help?

Thanks in advance

Assuming you have column headers in row 1 and the data does not exceed row
5000:

=SUMPRODUCT(--($A$2:$A$5000="ABC"),--($B$2:$B$5000="XYZ"),$C$2:$C$5000)


"DMcCormack" wrote:

Do anyone know if it is possible to do a sumif function for more than one
condition? What I want to do is sum the items in column C that meet the
criteria of column A = "ABC" and column B = "XYZ"

Can anyone help?

Thanks in advance