counting blank cells in a range

  • Thread starter Thread starter CarlM
  • Start date Start date
C

CarlM

I have several people using a master spreadsheet, of basically a to do list,
when they are done they enter a date in a cell, I need to count blank cells
in the completed column.

person date
0 9/16/09
0
1
1
2 9/16/09
2 9/16/09
3
3

I need the formula to give me the answer of 5 with the above senario.

Thanks in Advance
 
Try this, assuming the date column is column B:

=COUNTIF(B2:B9,"")

A more robust way might be:

=SUMPRODUCT(--(A2:A9<>""),--(B2:B9=""))

Hope this helps.

Pete
 
Back
Top