| 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 | |||
Hybrid Mode
