Please find an explanasion

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

If this post helps click Yes
---------------
Jacob Skaria


"ZTamsen" wrote:

Thanks so much. It works perfectly. Can you explain what function the
double negative sign provides? If I delete them, the function returns a zero
value, but by basic math skills tell me that a double negative should cancel
itself out. What am I missing?

again, thanks so much,
zt

"Jacob Skaria" wrote:

Try
=SUMPRODUCT(--ISERR(C1:C10))

If this post helps click Yes
---------------
Jacob Skaria


"ZTamsen" wrote:

All -

Thanks in advance for the help. I have a long list of text values and I
want to count the number of cells that contain error values rather than text.
How do I put a countif and iserr function together to get the total number
of error values in that list?

Much thanks,
zt