Maybe this:

=COUNTIF(A1:A16,"*")

That will count all the *text* entries in the range and exclude the #N/As

--
Biff
Microsoft Excel MVP


"Dax Arroway" wrote in message
...
I have a list of names (column A) which ends in a bunch of #N/As (because
they include formulas that are... well... N/A) and I'd like to count the
names, not the "#N/A"s. Can someon help me out with a formula please?

I'm thinking it should be something like:

=COUNTIF(A1:A16, NOT "#N/A")

But that doesn't work!

In English that would be, Please count all the names and disregard the
cells
with #N/A in them. How many people is that?

Please help and thanks in advance!
--Dax