Thread: Counting the number of errors in a worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default Counting the number of errors in a worksheet
I have a worksheet containing formulas in the range of A1:DG5000. I wrote
the following formula to count the number of (any) errors in that range:

=COUNT(ISERROR(A1:DG5000))

I know there are 4 cells containing errors, but the aforementioned formula
returns a value of 1.
Any help would be greatly appreciated. Thanks.
Reply With QuoteReply With Quote