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

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?

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?

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?

You can't reference the whole column if you use Excel up to and included
2003, you would need to use

A5:A65535


having said that, do you really have that many rows? If you do formula like
that might slow down the workbook quite a bit

--


Regards,


Peo Sjoblom

"Tommy" wrote in message
...
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?

Thanks Peo! That really help without referencing the whole column. Well,
the project I am working on continuosly add data to the rows and I thought it
would be easier to reference the column. So I set the max to 10000 rows. I
was also confused by reading some of the other discussions and wasn't aware
that they were talking about 2007 or not. I didn't know that couldn't be
done in 2003 and prior.

Thanks again!

Tommy

"Peo Sjoblom" wrote:

You can't reference the whole column if you use Excel up to and included
2003, you would need to use

A5:A65535


having said that, do you really have that many rows? If you do formula like
that might slow down the workbook quite a bit

--


Regards,


Peo Sjoblom

"Tommy" wrote in message
...
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?