-- 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.