You can use sumproduct for that:

=SUMPRODUCT((A1:A4="red")*(B1:B4="car"),C1:C4)

this will sum C1:C4 when A1:A4="red" and B1:B4="car".




"Rachelle" wrote in message
...
I need to create a "sumif" formula in excel that allows me to dictate
MULTIPLE criteria...for example, in range a1:c10, I want to sum cell c3
only
if a1="value" and b1="value", and so on down the line...ideally, I would
creat a formula that looks like this:

=sumif(a1:c10,a1:a10="value1"AND b1:b10="value2",c1:c10)

I've tried layer "if" and "and" formulas in the sumif formula; nothing
seems
to work.

HELP!