Thread: count of 'err'
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default count of 'err'

You're welcome.


"Denise" wrote in message
...
actually it was a an if statement, but it works the same.
Thank you so much.

"Gaurav" wrote:

=COUNTIF(A2:A10,"#N/A") ??


"Denise" wrote in message
...
How can I count the number of ERR's I get in a vlookup in a column?