formula to count easily
The Error Types return text strings
They're not text strings but I don't know the exact terminology. They're not
logicals or booleans but I call them logicals even though Excel defines
logical values as either TRUE ot FALSE.
A1 = #DIV/0!
=ISTEXT(A1) = FALSE
=COUNTIF(A1:A100,"#DIV/0!")
=COUNTIF(A1:A100,#DIV/0!)
Both work.
Biff
"Elkar" wrote in message
...
The Error Types return text strings, so a simple COUNTIF should work:
=COUNTIF(A1:A100,"#DIV/0!")
=COUNTIF(A1:A100,"#NAME?")
etc...
HTH,
Elkar
"driller" wrote:
in my formulation list workbook, i have one column filled with different
formulas...
result can be a text, number, and all sorts of known error types....e.g.
#NULL!
#DIV/0!
#VALUE!
#REF!
#NAME?
#NUM!
#N/A
I like to count (A1:A100) how many formula are bearing each error.type...
this may enlighten me how to clean the list of formula bearing correct
results...
pls. bear with me...
regards,
driller
--
*****
birds of the same feather flock together..
|