Hi

Try something like:
=COUNTIF(A:A,"y")+COUNTIF(A:A,"n")

Hope this helps.
Andy.

"Boulder257" wrote
in message ...

If I have in Column A three different potential results, say "y" "n" and
"n/a" and I want to use Countif to count only those that result in "y"
and "n" how can I do this?


--
Boulder257
------------------------------------------------------------------------
Boulder257's Profile:
http://www.excelforum.com/member.php...o&userid=20053
View this thread: http://www.excelforum.com/showthread...hreadid=505279