Function for find "???"

[MartinV10]

I have a question.
When using the function "= COUNTIF (B3: B11;" yes ")" my excel will simply come out the number of "yes" contained in that location. (There are 3)
When using the function "= COUNTIF (B3: B11;" no ")" my excel will simply come out the number of "no" contained in that location. (There are 3)
But when using the function to calculate the expression "???" : = COUNTIF (B3: B11; "???") I get the wrong number (There are 3 again but Excel counts 6)

Please advise how to do it to calculate the number of cells in which it is "???".

Thank you

[Olly]

? is the wildcard character for any single character.

To search for a literal question mark, escape it with a tilde: ~?

So, your formula in G3 becomes:

Please Login or Register  to view this content.

[MartinV10]

Thank you sir

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'Add Reputation' to those who helped you. Thanks.