Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with "OR" conditions
How do I display results if ANY of three conditions are True rather than when
ALL 3 conditions are True? My formula is =SUMPRODUCT(--(AC11:AC1152="Condition 1"),--(AC11:AC1152="Condition 2"),--(A11:A1152="Condition 3")) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with "OR" conditions
If you have only three conditons then simply add up three SUMPRODUCTS, one
for each condition.. "Gary" wrote: How do I display results if ANY of three conditions are True rather than when ALL 3 conditions are True? My formula is =SUMPRODUCT(--(AC11:AC1152="Condition 1"),--(AC11:AC1152="Condition 2"),--(A11:A1152="Condition 3")) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with "OR" conditions
Following worked in Excel 2007
=SUMPRODUCT(--(AC11:AC1152={"Condition1","Condition2","Condition 3"})) "Gary" wrote: How do I display results if ANY of three conditions are True rather than when ALL 3 conditions are True? My formula is =SUMPRODUCT(--(AC11:AC1152="Condition 1"),--(AC11:AC1152="Condition 2"),--(A11:A1152="Condition 3")) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with "OR" conditions
=SUMPRODUCT((AC11:AC1152="Condition 1")+(AC11:AC1152="Condition
2")+(A11:A1152="Condition 3")) assuming that condition 3 can't be true if either of the others is also true. [Obviously it coudn't be if it were looking at the same column that the other two. use.] -- David Biddulph "Gary" wrote in message ... How do I display results if ANY of three conditions are True rather than when ALL 3 conditions are True? My formula is =SUMPRODUCT(--(AC11:AC1152="Condition 1"),--(AC11:AC1152="Condition 2"),--(A11:A1152="Condition 3")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Sumproduct on multiple "or" conditions | Excel Worksheet Functions | |||
Sumproduct, multiple conditions.. but I also want to "minus" somet | Excel Worksheet Functions | |||
SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |