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