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