From: BuckeyeJohn21 on
I have a workbook with two sheets. On the first sheet are a series of dates.
On the second tab, I am trying to total the number of entries within
specific months using date ranges from the first sheet. I can't for the life
of me figure out what formula to use to do this. Can anyone help. An
example of the data I am trying to formulate would be a count of claims
>1/31/10 but < 3/1/10. Please help.
From: Pete_UK on
It would help to know which column in sheet1 is used for your dates
and other data.

Assuming your dates are in column D, then you could use something like
this:

=SUMPRODUCT(--(TEXT(Sheet1!D$1:D$100,"mmm-yy")="Apr-09"))

to count the number of entries with dates in April 2009. If you have
different types of activity in column T, for example, and you want a
count of column T containing "claim" during September 2009, you could
do this:

=SUMPRODUCT(--(TEXT(Sheet1!D$1:D$100,"mmm-yy")="Sep-09"),--(Sheet1!T
$1:T$100="claim"))

Please try to be more specific in your description.

Hope this helps.

Pete

On Dec 23, 4:27 pm, BuckeyeJohn21
<BuckeyeJoh...(a)discussions.microsoft.com> wrote:
> I have a workbook with two sheets.  On the first sheet are a series of dates.
>  On the second tab, I am trying to total the number of entries within
> specific months using date ranges from the first sheet.  I can't for the life
> of me figure out what formula to use to do this.  Can anyone help.  An
> example of the data I am trying to formulate would be a count of claims
>
>
>
> >1/31/10 but < 3/1/10.  Please help.- Hide quoted text -
>
> - Show quoted text -

From: "David Biddulph" groups [at] on
=COUNTIF(A8:A20,">"&DATE(2009,1,31))-COUNTIF(A8:A20,">="&DATE(2009,3,1))
Adjust your range to suit.
--
David Biddulph


"BuckeyeJohn21" <BuckeyeJohn21(a)discussions.microsoft.com> wrote in message
news:209F7B0A-7662-426E-94E1-9BF4072D765A(a)microsoft.com...
>I have a workbook with two sheets. On the first sheet are a series of
>dates.
> On the second tab, I am trying to total the number of entries within
> specific months using date ranges from the first sheet. I can't for the
> life
> of me figure out what formula to use to do this. Can anyone help. An
> example of the data I am trying to formulate would be a count of claims
>>1/31/10 but < 3/1/10. Please help.


From: BuckeyeJohn21 on
Thank you David. Works great! Sure appreciate the help.

"David Biddulph" wrote:

> =COUNTIF(A8:A20,">"&DATE(2009,1,31))-COUNTIF(A8:A20,">="&DATE(2009,3,1))
> Adjust your range to suit.
> --
> David Biddulph
>
>
> "BuckeyeJohn21" <BuckeyeJohn21(a)discussions.microsoft.com> wrote in message
> news:209F7B0A-7662-426E-94E1-9BF4072D765A(a)microsoft.com...
> >I have a workbook with two sheets. On the first sheet are a series of
> >dates.
> > On the second tab, I am trying to total the number of entries within
> > specific months using date ranges from the first sheet. I can't for the
> > life
> > of me figure out what formula to use to do this. Can anyone help. An
> > example of the data I am trying to formulate would be a count of claims
> >>1/31/10 but < 3/1/10. Please help.
>
>
> .
>