Counting Blank Cells until end of Column

[Benjamin]

I know how to count all database entries that have a close date.
The problem lies in counting all entries that don't have any date in the
cell.
I need to count all the cells that are blank but only until the last row
that has recently been filled in. Is there a way to say count blanks until
end? or Count only if another column is filled out and if the date closed
field is blank? Any thoughts?

 

[PatrickA]

Benjamin,

How do you know if a row has "recently been filled in"?

If there is a column you can count cells in that is filled in when
Date is not, then:

Count those "filled" rows
Count all your date entries

filled rows minus date entries = unfilled dates for valid rows

Correct?

Patrick

 

[T. Valko]

Assuming the ranges will be contiguous (no empty cells between entries):

=COUNTA(A:A)-COUNTA(B:B)

...........A..........B
1........x...........x
2........x...........x
3........x............
4........x............
5........x............

The above formula returns 3.

 

[Shane Devenshire]

Hi,

Suppose your column that is filled all the way down is A and the date column
is B

=SUMPRODUCT(--(A1:A500<>""),--(B1:B500=""))