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.

--
Biff
Microsoft Excel MVP


"Benjamin" wrote in message
...
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?