Prev: thousands of dollars in cash overflowing your PAYPAL account
Next: V-lookup and Countif
From: BuckeyeJohn21 on 23 Dec 2009 11:27
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 23 Dec 2009 11:41
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 23 Dec 2009 11:49
=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 23 Dec 2009 13:44
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.
>
>
> .
>
 | 
Pages: 1
Prev: thousands of dollars in cash overflowing your PAYPAL account
Next: V-lookup and Countif