Count Blank Cells with Conditions
On 1/03/2012 11:11 AM, CNWatsonJr wrote:
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.
+-------------------------------------------------------------------+
|Filename: excelshot.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=301|
+-------------------------------------------------------------------+
Hi
As for using Text for preservation of your numbering format, you can use
a Custom Number Format that = 00 which will display any single digit
number with a leading zero.
This will get you counts of the specific criteria of each Group,
although I could not get the right syntax for the additional date range
criteria to work.
Group. 1 =COUNTIF($B$2:$B$10,"=01")
Group. 2 =COUNTIF($B$2:$B$10,"=02")
Group. 3 =COUNTIF($B$2:$B$10,"=03")
Group. 4 =COUNTIF($B$2:$B$10,"=04")
Non-Grouped =COUNTIF($B$2:$B$10,"")
HTH
Mick.
|