Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell: count occurance of letters in a column | Excel Worksheet Functions | |||
How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |