View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default Count Names NOT #N/A

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