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?