Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |