counting blank cells in a range

[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

 

[Pete_UK]

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

 

[KC]

=COUNTBLANK(A2:A10)

or

=COUNTIF(A2:A10,"")

-kc
*Click YES if this helps