I am doing something similar. I have a column (AX) full of several different
texts. These texts are OPEN, CLOSED, WORKING ... I have another column
with dates (B). I want to have all the data on the 1st worksheet. I want to
have 4 subsequent worksheets, one for each quarter of the year. I want
worksheet 2 to give me a total of open cases between 1-1-2005 and 3-31-2005.
Then another for total closed and total working....etc.

I tried to use this formula, but it returns a value of zero.....

=SUMPRODUCT(--(AX2:AX61="OPEN"),--(B2:B61=--"2005-10-01"),--(B2:B61<=--"2005-12-31"))

Do I have something messed uP?

"MAC" wrote:

That did it! Thanks Bob!

"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?