Hi,

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Benjamin" wrote:

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?