| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF - Not an Error
Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc. =COUNTIF(A1:A5000, ??????) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using "Countif" in macro gives compile error | Excel Discussion (Misc queries) | |||
| Countif error using multiple workbooks | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| countif / sumif function error | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Threaded Mode
