Countif IsErr

  • Thread starter Thread starter ZTamsen
  • Start date Start date
Z

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
 
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
 
Back
Top