| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting the number of errors in a worksheet
I have a worksheet containing formulas in the range of A1:DG5000. I wrote
the following formula to count the number of (any) errors in that range: =COUNT(ISERROR(A1:DG5000)) I know there are 4 cells containing errors, but the aforementioned formula returns a value of 1. Any help would be greatly appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number when you have a number and text | Excel Worksheet Functions | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| I need a unique number to be created per worksheet | Excel Discussion (Misc queries) | |||
| Avoiding Errors When Attempting To Retrieve Data From A Non-existant Worksheet | Excel Worksheet Functions | |||
| ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN | Excel Worksheet Functions | |||
Threaded Mode
