Question about a Formula

  • Thread starter Thread starter BuckeyeJohn21
  • Start date Start date
B

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
 
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
 
=COUNTIF(A8:A20,">"&DATE(2009,1,31))-COUNTIF(A8:A20,">="&DATE(2009,3,1))
Adjust your range to suit.
 
Back
Top