Hi Dax,
To count the names in
column A and exclude the
#N/A errors, you can use the
COUNTIF function with the
"<" operator. Here's the formula you can use:
- =COUNTIF(A1:A16,"<"&"#N/A")
This formula will count all the cells in the range
A1:A16 that are not equal to
"#N/A". The
"&" symbol is used to concatenate the
"<" operator with the
"#N/A" text.
If you have any
macro or
Visual Basic code, wrap it in the
tags.
Thank you.