One way:

=SUMPRODUCT(--(A1:A10="value1"),--(B1:B10="value2"),C1:C10)


for an explanation of "--", see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"Rachelle" wrote:

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!