=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.
|