ExcelBanter - How can I count #N/A in a column?

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

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

- - How can I count #N/A in a column? (https://www.excelbanter.com/excel-worksheet-functions/8126-how-can-i-count-n-column.html)

Rasoul Khoshravan Azar

How can I count #N/A in a column?

How can I count #N/A in a column?
TIA, Rasoul Khoshravan

Domenic

In article ,
"Rasoul Khoshravan Azar" wrote:

How can I count #N/A in a column?
TIA, Rasoul Khoshravan

Try...

=COUNTIF(A1:A10,#N/A)

Hope this helps!

Daniel.M

Hi,

This array formula (Ctrl-Shift-Enter)

=SUM(--ISNA(A1:A100))

Notice you can't choose ALL the column. Use a range instead.

Regards,

Daniel M.

"Rasoul Khoshravan Azar" wrote in message
...
How can I count #N/A in a column?
TIA, Rasoul Khoshravan

Rasoul Khoshravan Azar

Dear Domenic
Thanks. It was easy but informative.
Regards, Rasoul

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