Question about a Formula

[BuckeyeJohn21]

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

 

[Pete_UK]

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$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$100,"mmm-yy")="Sep-09"),--(Sheet1!T
$1:T$100="claim"))

Please try to be more specific in your description.

Hope this helps.

Pete

 

[David Biddulph]

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

 

[BuckeyeJohn21]

Thank you David. Works great! Sure appreciate the help.