Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to count blanks cells with conditions.
In column 'A' I have a list of dates and in column 'B' I have a list of group numbers (two digits, formatted as text - to preserve two digits under the value of 10). Some of the cells in column 'B' are blank (no group number assigned). I need to count the blank cells that occur between a specific date range. I have tried countif, sumproduct, and nested if functions but I am just not getting it right. I am either getting a value of 0, false or just a plain error. Any help would be greatly appreciated. Last edited by CNWatsonJr : March 1st 12 at 12:26 AM Reason: add image |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting non-blank cells with conditions | Excel Discussion (Misc queries) | |||
count nonblank cells with conditions | Excel Worksheet Functions | |||
Count and Sum of cells if conditions fulfilled | Excel Worksheet Functions | |||
I want to count relying upon conditions in other cells | Excel Discussion (Misc queries) | |||
Count the number of Cells in one ROW with conditions | Excel Worksheet Functions |