View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CarlM[_2_] CarlM[_2_] is offline
external usenet poster
 
Posts: 3
Default counting blank cells in a range

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