Counting Blank Cells until end of Column

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

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?
 
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
 
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.
 
Hi,

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

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