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

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

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

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