Count error frequency in huge column:full time

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

Try...

="There are "&SUMPRODUCT(--(ISERROR(FullDate)))&" Error(s) below."

Hope this helps!

In article <73aGe.53866$rb6.43455@lakeread07>,
"PJohnson" <[email protected]> wrote:

> 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

Try this:

="There are "&SUMPRODUCT(--ISERROR(FullDate))&" error(s) below."

Does that help?

--
Regards,
Ron


"PJohnson" wrote:

> 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
>
>
>