count errors
Try this (normally entered, not an array):
=SUMPRODUCT(--(ISERROR(BJ17:BJ24)))
Your formula (array entered) will work like this:
=COUNT(IF(ISERROR(BJ17:BJ24),1))
Biff
"Bruce" wrote in message
...
Trying to count the erros on my page.
Came up with the following array formula but does not work. Range
BJ17:BJ24
does contain errors.
=COUNT(IF(ISERROR(BJ17:BJ24),BJ17:BJ24))
Any ideas?
Bruce
|