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
|