B* vs BH with countif statement

[Dennisr53]

Hi Everyone,

I am using countif and ran across this issue: I want to count how many "B*" and also "BH" but am getting the * used as a wild card and only want to count it as a character.

All suggestions welcome.

Thanks, Dennis

 

[mikerickson]

=COUNTIF(H:H,"B~*") will count "b*" but not "bh"

wildcards preceded by a ~ are treated as normal characters.

 

[Dennisr53]

Thank you Mike. This is going to help me a lot. Much appreciated. Dennis

=COUNTIF(H:H,"B~*") will count "b*" but not "bh"

wildcards preceded by a ~ are treated as normal characters.