Of course it does, thanks for the correction

Mike

"JE McGimpsey" wrote:

Your last example will count any cell that contains a single character -
the question mark acts as a wild card.

To look for the question mark itself, you need to escape it with the
tilde character:

=COUNTIF(A1:A30,"~?")


In article ,
Mike H wrote:

try this

=COUNTIF(A1:A30,"*Mexico*")

and

=COUNTIF(A1:A30,"?")