Countif IsErr
 

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

Countif IsErr
 

Maybe something like:

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

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"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

Countif IsErr
 

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

Countif IsErr
 

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

Countif IsErr
 

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

Countif IsErr
 

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

"ZTamsen" wrote in message
...
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

Countif IsErr
 

Hello,

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

Regards,
Bernd