COUNTIF - need it more flexible

[Sparkle99]

Currently a simple formula....
=COUNTIF(A1:A99,"Open")
does what you expect and returns a total where the values in col A are "Open".

However, I need to also count "Open/R1" as part of the same total.
But this could be "Open/R2", "Open/R3" etc... to "Open/R9".

I could do COUNTIF()+COUNTIF()+... but does anyone have a more elegant way of doing this ?

Thanks in advance for your brainpower.

 

[Andrew Poulsom]

Try:

=COUNTIF(A1:A99,"Open*")

 

[Sparkle99]

Thanks for the most minor of adjustments !