help with =sumif statement

Can you have two conditions in a =sumif statement. Meaning, sum col C if "x" is in col A and "y" is in col B, then and only then sum col C.

Thanks!

Try SUMPRODUCT

=SUMPRODUCT((A1:A100="x")*(B1:B100="y"),C1:C100)

adjust ranges as necessary but you can't use whole columns

yes worked beautifully, but needed to put two "--" infront of the ranges for col A and B.

looked like this:

=SUMPRODUCT(--(A1:A100="x"),--(B1:B100="y"),C1:C100)

Originally Posted by Mile029

worked beautifully, but needed to put two "--" infront of the ranges for col A and B.

Well, you can certainly do it that way too but the formula I posted would give the same result

yes yours worked nicely too.