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