Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This is somewhat related to my Countdown Birthday Flag question, however a
bit different, so I chose to generate a "New" question for this... I have a flag in Column G which identifies a "countdown" to someone's Birthday: 10-Day(s) Till Birthday-Send Letter 9-Day(s) Till Birthday-Send Letter The above flag appears between Days 10-1 (not on the actual Birthday however). In cell G3, I merely want to "count" how many times the flag appears in Column G, but I'm having difficulty doing this. I tried t hat which you see below to no avail. In addition, the formula below needs to be more refined so that the count only takes in the parameters of 10-1 Day(s) Till Birthday-Send Letter: =COUNTIF(G4:G3500<=",10-Day(s) Till Birthday-Send Letter") Any ideas? Thanks, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting Question | Excel Discussion (Misc queries) | |||
A counting question... | Excel Worksheet Functions | |||
Counting question | Excel Worksheet Functions | |||
Counting question | Excel Discussion (Misc queries) |