View Single Post
  #1   Report Post  
PJohnson
 
Posts: n/a
Default Count error frequency in huge column

I have a named range called "FullDate". It is 22,000 rows. Instead of
scrolling down each time, I just wanted to put a formula at the top that
counted the occurences of any type of errors, if there are any.

I have everything including:

="There are " =COUNTIF(FullDate,ISERROR(FullDate)="TRUE") & " Error(s)
below."

Which, when calculated, was to read something like: "There are 0 Errors
below"

But this does not work. I cannot seem to capture the error text to count it.

Any help would be appreciated.

Pete