Counting Values amongst #N/As
 

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?

Counting Values amongst #N/As
 

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

--
__________________________________
HTH

Bob

"Paul W Smith" wrote in message
...
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?

Counting Values amongst #N/As
 

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

and

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


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113005

Counting Values amongst #N/As
 

or even

=COUNTIF(K:K,NA())

--
__________________________________
HTH

Bob

"Paul W Smith" wrote in message
...
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?