Counting Blank Cells until end of Column
 

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?

Counting Blank Cells until end of Column
 

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

Counting Blank Cells until end of Column
 

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?

Counting Blank Cells until end of Column
 

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?