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

  • Thread starter Thread starter Rasoul Khoshravan Azar
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort + & - numbers together 1
How can I get a unique list of a column? 2
Count Names NOT #N/A 2
Formula Count dates multiple criteria 3
Count functions 4
Avoid counting #N/A filled cells, or avoiding #N/A altogether 5
Count the Y's in a filtered column that contains Y and N 1
hyperlinking a cell in many sheets 8

Back
Top