D
Danny Boy
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
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