counting within date range

  • Thread starter Thread starter autumn
  • Start date Start date
A

autumn

I need to get a count month by month of the number of transactions within the
month (ie all on worksheet "NEW", column O, that occur in October, Nov, etc)

I tried using COUNTIF and it worked for one month using:
=(COUNTIF(New!O:O,">=10/01/2008"))-(COUNTIF(New!O:O,">10/31/2008")) but not
in the next using essentially the same thing:
=(COUNTIF(New!O:O,">=11/1/2008"))-(COUNTIF(New!O:O,">11/31/2008")).

I also tried IF/and to see if that
helped:=IF(AND(New!O:O>=DATE(2008,9,1)),1,""), hoping I could add the second
half later and that didn't work at all.

What's the secret?
 
Easiest way would be to create a Pivot Table, with Count of
transactions, and group the dates by Month.

Of course,the problem with your formulae could be that November has only
30 days, not 31.
 
I'd use something like:

= COUNTIF(New!O:O,">="&date(2008,10,1)) - COUNTIF(New!O:O,">"&date(2008,10,31))
 
Back
Top