The OP is following up from a couple of earlier threads. It was established
in those threads that there is always something in the cell... either the
number of days until a birthday, a Happy Birthday message or (when 10 or
less days remain until the birthday) the "send letter" message. His "send
letter" message is the only entry that will have a dash in it, hence the
formula I proposed elsewhere in this thread.

--
Rick (MVP - Excel)


"Shane Devenshire" wrote in
message ...
Hi,

This might work:

=COUNTIF(G4:G3500,"<")
or more likely
=SUMPRODUCT(--(LEN(G4:G3500)0))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Danny Boy" wrote:

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