counting within date range

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

JE McGimpsey

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

Dave Peterson

I'd use something like:

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