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

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

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