Counting when at least one condition is met

[andrewc]

Hi,

The COUNTIFS function counts the number of occurrences when ALL stipulated conditions are met.

Can someone please suggest a formula to count the number of times that AT LEAST ONE condition is satisfied?

Thanks!

[bebo021999]

Maybe:
=COUNTIF(RANGE,Condition_1)+COUNTIF(RANGE,Condition_2)
Or:
=SUMPRODUCT((RANGE=Condition_1)+(RANGE=Condition_2))

[ragulduy]

Allkey suggested this alteration to me recently that I like:
=SUM(COUNTIF(RANGE,{Condition_1,Condition_2,Condition3}))
e.g.
=SUM(COUNTIF(A1:A100,{"a","b"}))

[andrewc]

Thanks very much