Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Non Blank Cells | Excel Discussion (Misc queries) | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Counting non-blank cells | Excel Discussion (Misc queries) | |||
Counting blank cells | Excel Discussion (Misc queries) | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) |