Question about a Formula
 

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.

Question about a Formula
 

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

Question about a Formula
 

=COUNTIF(A8:A20,""&DATE(2009,1,31))-COUNTIF(A8:A20,"="&DATE(2009,3,1))
Adjust your range to suit.
--
David Biddulph


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

Question about a Formula
 

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


.