Counting entries based on month

**mamig** · 10-21-2009, 10:09 AM

I have a column of dates and want to count how many times there is an entry for a particular month. example:

(column D)
7/4/2009
7/13/2009
7/22/2009
8/1/2009
8/6/2009
9/15/2009

I want to be able to coun (countif?) how many times there is a July listing, August listing, etc. I have tried countif and sumproduct with no luck.
=COUNTIF(D3:D20,">=7/1/2009")+COUNTIF(D3:D20,"<=7/31/2009")
=SUMPRODUCT(--(D3:D20>="7/1/2009")*(D3:D20<="7/31/2009"))
I have made them arrays. Any assistance would be appreciated.

**NBVC** · 10-21-2009, 10:17 AM

TRy

=COUNTIF(D3:D20,">=7/1/2009")-COUNTIF(D3:D20,">7/31/2009")

or

=SUMPRODUCT(--(D3:D20>="7/1/2009"+0)*(D3:D20<="7/31/2009"+0))

**NBVC** · 10-21-2009, 10:17 AM

TRy

=COUNTIF(D3:D20,">=7/1/2009")-COUNTIF(D3:D20,">7/31/2009")

or

=SUMPRODUCT(--(D3:D20>="7/1/2009"+0)*(D3:D20<="7/31/2009"+0))

**mamig** · 10-21-2009, 10:45 AM

Thank you. They both worked great

**NBVC** · 10-21-2009, 10:47 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save