counting blank cells in a range
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
On Sep 17, 12:38*am, CarlM wrote:
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
|