Count error frequency in huge column

  • Thread starter Thread starter PJohnson
  • Start date Start date
P

PJohnson

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!
 
Try this:

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

Does that help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a String into a date format 3
Counting for frequency 2
Count frequence in one column 1
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Count the frequency for every change in numbers 6
Counting frequency in unsorted data 2
Counting something 5
Countifs bites again 4

Back
Top