View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default formula to count easily

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..