Count Names NOT #N/A

  • Thread starter Thread starter Dax Arroway
  • Start date Start date
D

Dax Arroway

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
 
Maybe...

=COUNTIF(A1:A16,"<>#n/a")



Dax said:
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
Click to expand...
 
Maybe this:

=COUNTIF(A1:A16,"*")

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