Thread
:
Counting errors
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
kittronald
external usenet poster
Posts: 162
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.
Reply With Quote
kittronald
View Public Profile
Find all posts by kittronald