CountIf Question

[Boulder257]

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?

 

[Dave Peterson]

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

or if you have lots:

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

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Boulder257]

Perfect. Thanks guys!