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.

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.

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

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

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.

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

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.

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.