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