try this

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

and

=COUNTIF(A1:A30,"?")

Mike



"BlueWolverine" wrote:

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

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!