Thread: Counting errors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
 
Posts: 162
Default Counting errors

In Microsoft Excel 2007, how can you count the number of Excel errors
(i.e., #VALUE!, #N/A, etc.) in a named range ?

Using =COUNTIF(named_range,"#*") doesn't work with Excel error values.



- Ronald K.