You could always use:
=countif(a1:a10,"y")+countif(a1:a10,"n")+countif(a 1:a10,"n/a")

or if you have lots:

=sum(countif(a1:a10,{"y","n","n/a"}))


Boulder257 wrote:

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

--

Dave Peterson