=IF(ISERROR(AVERAGE(C5:H1000)),"PROBLEM","OK")
Note: the range being verified must contain at least one numeric value.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)
"Mark F"
wrote in message
...
Doesn't do what I want: I want ANY error to show up in some fixed
location.
There will be 1000s of cells.
"Mark F"