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

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.

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

--

HTH

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


"djpaik" wrote in message
...
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.

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

djpaik wrote:

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.