View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 94
Default counting blank cells in a range

=COUNTBLANK(A2:A10)

or

=COUNTIF(A2:A10,"")

-kc
*Click YES if this helps

"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