On May 14, 3:27*am, kittronald wrote:
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.

Hi You can use following array formula also

={SUM(ISERROR(named_range)*1)}
or
={SUM(IF(ISERROR(named_range),1,0))}