Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count names and occurrences | Excel Worksheet Functions | |||
Count Names | Excel Worksheet Functions | |||
Count Names | Excel Worksheet Functions | |||
Count Names | Excel Discussion (Misc queries) | |||
Count names | Excel Worksheet Functions |