Hi,

I see that it is an old post, however I am in a similar situation. The
formula you provided below doesn't reference the entire column. I am
referencing data from another worksheet in an entire column. Can you help?

Tommy

"Bob Phillips" wrote:

=SUMPRODUCT(--(C2:C200="text"),--(F2:F200=--"2005-01-01"),--(F2:F200<=--"20
05-01-31"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MAC" wrote in message
...
Col C = Text and Col F = dates
I would like to count the # of times a value occurs in Col C based on a
date
range in Col F.
Does anybody have an answer to this?