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

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

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

Perfect. Thanks guys!


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