Thread: count errors
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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