| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
One way is to try it as:
=SUMPRODUCT(--(ISERROR(A1:DG5000))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
Max - That did the trick! Thanks!
Bob "Max" wrote: One way is to try it as: =SUMPRODUCT(--(ISERROR(A1:DG5000))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
You're welcome, Bob !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote in message ... Max - That did the trick! Thanks! Bob |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
Thanks for this answer Max - it's helped me out aswell.
Can I just ask though, what does the -- mean inbetween the two brackets ie (--( and how does it affect the formula? Thanks, AW "Max" wrote: One way is to try it as: =SUMPRODUCT(--(ISERROR(A1:DG5000))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
-- is a way of converting a Boolean (True or False) to a number (1 or 0).
http://www.mcgimpsey.com/excel/variablerate1.html is one place which gives an explanation. -- David Biddulph "ArcticWolf" wrote in message ... Thanks for this answer Max - it's helped me out aswell. Can I just ask though, what does the -- mean inbetween the two brackets ie (--( and how does it affect the formula? Thanks, AW "Max" wrote: One way is to try it as: =SUMPRODUCT(--(ISERROR(A1:DG5000))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
How about:
=SUMPRODUCT(--(ISERROR(A1:dg5000))) Bob wrote: 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. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting the number of errors in a worksheet
Dave - That did the trick! Thanks!
Bob "Dave Peterson" wrote: How about: =SUMPRODUCT(--(ISERROR(A1:dg5000))) Bob wrote: 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. -- Dave Peterson |
| Reply |
| 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 | |||
Hybrid Mode
