Counting Values amongst #N/As

[Paul W Smith]

I have a column of Vlookups, I need to know how many are returning a value
and how many are returning #NAs, what formulas do I use to do this?

 

[Bob Phillips]

=COUNTIF(K:K,"#N/A")

 

[NBVC]

=Countif(A1:A100,"#N/A") to count #N/A

and

=Countif(A1:A100,"<>#N/A") to count values other than "#N/A"

 

[Bob Phillips]

or even

=COUNTIF(K:K,NA())