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