Using Count Function

[madchemist]

I am trying to figure out how to count all of the blank cells in a column. I have an admin who knows very little about excel and I dont want to have to explain to her how to change the ranges within the =COUNTBLANK(K1:K6921) formula because rows are constantly being added.

If I do CountBlank(K:K) it returns way too many because it is counting all of the empty cells after the data ends.

How can I have it only count the empty cells within the data range. Note* the data is consecutive. There will be no empty rows until after the data ends.

Thanks!

 

[Aladin Akyurek]

What type of data does column K house - text or numeric?

 

[madchemist]

the header is text and the rest of the column is numeric dates such as...

2/10/2005 12:00:00 AM

 

[madchemist]

bump...


sorry I need to finish this today....Someone must know a formula I can use for this

 

[barry houdini]

Try

=COUNTBLANK(K1:INDEX(K:K,MATCH(10^7,K:K)))