Countif IsErr

[ZTamsen]

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

 

[JBeaucaire]

Maybe something like:

=SUMPRODUCT(--(ISERROR(A1:A20)))

 

[Jacob Skaria]

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

If this post helps click Yes

 

[ZTamsen]

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]

Please find an explanasion

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

If this post helps click Yes

 

[David Biddulph]

http://www.mcgimpsey.com/excel/formulae/doubleneg.html
http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[Bernd P]

Hello,

Another one:
Array-enter
=SUM(--ISERROR(A1:A12))

Regards,
Bernd