Counting "Question Marks"
=COUNTIF(A:A,"~?")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Robin Blackwell" wrote in message
...
Hi all, is there a simple function that will allow me to count the number
of
"?" in a column of data? I have a longish column that contains only "y",
"n",blanks, or "?". I can use COUNTIF functions to count the number of "y"
and "n", COUNTBLANK to count the number of blank cells, but if I enter a
COUNTIF using "?", it returns a count of all cells containing data. Help
please! Regards, Robin
|