Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
count errors
XL 2002 SP3
Win XP HE SP1 Follow-up to: microsoft.public.excel How do I count errors #N/A in column A that has both errors and proper values in some of its rows? I am trying a countif but struggling w/ the error part e.g. isna or iserror, etc. tx. |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
count errors
=COUNTIF(A1:A100,#N/A)
"stef" wrote: XL 2002 SP3 Win XP HE SP1 Follow-up to: microsoft.public.excel How do I count errors #N/A in column A that has both errors and proper values in some of its rows? I am trying a countif but struggling w/ the error part e.g. isna or iserror, etc. tx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
Tracking Errors | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |