Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

Hi,

Try this

=sumproduct((range="05/15/2009")*(range="05/21/2009"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"NWO" wrote in message
...
Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

It's best to place your criteria in assigned cells, so that you can revise
the dates without having to change the formula itself.

Start date in B1,
End date in C1,

=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

OR, not using entire columns ... except in XL07,

=SUMPRODUCT((A1:A100=B1)*(A1:A100<=C1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"NWO" wrote in message
...
Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

Thank you. I was close. It seems to work. Please advise what the &
performs in the foprmula so I can better understand.

Mark :)

"RagDyer" wrote:

It's best to place your criteria in assigned cells, so that you can revise
the dates without having to change the formula itself.

Start date in B1,
End date in C1,

=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

OR, not using entire columns ... except in XL07,

=SUMPRODUCT((A1:A100=B1)*(A1:A100<=C1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"NWO" wrote in message
...
Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

Opss, I forgot one thing - each date in the column can have one of three
tiers (values I, II, or III). How would I expand the formula to do the counts
by date and then by tiers? For example, there could be 3 occurances of
5/1/2009, one occurance woudl have Tier I, and the other two occurances woudl
have Tier II.

Thnak you .

Mark :)

"RagDyer" wrote:

It's best to place your criteria in assigned cells, so that you can revise
the dates without having to change the formula itself.

Start date in B1,
End date in C1,

=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

OR, not using entire columns ... except in XL07,

=SUMPRODUCT((A1:A100=B1)*(A1:A100<=C1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"NWO" wrote in message
...
Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

Assume source dates in A2 down, tiers in B2 down
With Start date in B1, End date in C1, Tier in D1
you could use something like this:
=SUMPRODUCT((A2:A100=B1)*(A2:A100<=C1)*)*(B2:B100 =D1))
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"NWO" wrote:
Opss, I forgot one thing - each date in the column can have one of three
tiers (values I, II, or III). How would I expand the formula to do the counts
by date and then by tiers? For example, there could be 3 occurances of
5/1/2009, one occurance woudl have Tier I, and the other two occurances woudl
have Tier II.

Hi.

Received an error on the )*)*( part of the formula.

"Max" wrote:

Assume source dates in A2 down, tiers in B2 down
With Start date in B1, End date in C1, Tier in D1
you could use something like this:
=SUMPRODUCT((A2:A100=B1)*(A2:A100<=C1)*)*(B2:B100 =D1))
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"NWO" wrote:
Opss, I forgot one thing - each date in the column can have one of three
tiers (values I, II, or III). How would I expand the formula to do the counts
by date and then by tiers? For example, there could be 3 occurances of
5/1/2009, one occurance woudl have Tier I, and the other two occurances woudl
have Tier II.

Sorry, it should read:
=SUMPRODUCT((A2:A100=B1)*(A2:A100<=C1)*(B2:B100=D 1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"NWO" wrote:
Received an error on the )*)*( part of the formula.