ExcelBanter - count of 'err'

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count of 'err' (https://www.excelbanter.com/excel-worksheet-functions/185676-count-err.html)

denise

count of 'err'

How can I count the number of ERR's I get in a vlookup in a column?

Gaurav[_2_]

count of 'err'

=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?

denise

count of 'err'

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?

Gaurav[_2_]

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?

All times are GMT +1. The time now is 02:29 AM.