How do I sum (like sumif) but predicated on multiple criteria, in.

[djpaik]

How do I sum (like SUMIF) but predicated on multiple criteria, in Excel. I
belive there is a single function that will resolve this question. PS I do
not want to filter the document by column than sum.

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100=condition1),--(B1:B100=condition2),C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jerry W. Lewis]

The following requires both conditions 1 and 2
=SUMPRODUCT((condition1)*(condition2),sumRange)
To sum if either condition is met, use
=SUMPRODUCT((condition1)+(condition2),sumRange)
You can also combine AND and OR criteria with judicious use of parentheses.

Jerry