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