Hello,

Try this formula:
=SUMPRODUCT( --ISERROR(named_range) )



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.