sumproduct with "OR" conditions

G

Gary

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"))
 
S

Sheeloo

If you have only three conditons then simply add up three SUMPRODUCTS, one
for each condition..
 
S

Sheeloo

Following worked in Excel 2007
=SUMPRODUCT(--(AC11:AC1152={"Condition1","Condition2","Condition3"}))
 
D

David Biddulph

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