[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.

--
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?

[Shane Devenshire[_2_]]

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?