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