COUNTIF(RANGE,"?") and search for contains

[BlueWolverine]

How do I perform a countif with the criteria being I want to count the number
of question marks?

Also, can I do countifs in a if it contains something versus equals something?

Say a cell contains "Guadalajara, Mexico"

can I get somrhting like =countif(cell,contains"Mexico") to return a 1?

Thank you!

(Excel 2003 on XP Pro. Also curious how to do it in Excel 2007 on XP Pro)

Thanks

 

[Mike H]

try this

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

and

=COUNTIF(A1:A30,"?")

Mike

 

[JE McGimpsey]

One way:

To count single question marks

=COUNTIF(A:A,"~?")

To count the number of cells in a range that contain a question mark
anywhere within their content:

=COUNTIF(A:A,"*~?*")

Similarly,

=COUNTIF(A1,"*Mexico*")

 

[JE McGimpsey]

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,"~?")

 

[Mike H]

Of course it does, thanks for the correction

Mike

 

[BlueWolverine]

Thank you. That locks it up.

 

[BlueWolverine]

Let me clarify, that fixes my problems. I just reread my post that makes it
sound like I am being a smart @$$ and telling you your fix locks my computer
up. ALL GOOD!