count errors
 

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

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