Using COUNTIF to return the sum of dates that fall within a Month/Year range.

[avidcat]

I want to use a COUNTIF to return the sum of all the dates that fall within a given month/year.

For example:
E1 Contains the date July-2009

Column A has date entries such as July 3, 2009, July 18, 2009, August 4 2009...

In F1 I want to return the sum of all dates that fall within the month of E1.

I attached an example, I appreciate any help with this.

thanks,
Nick

[NBVC]

Try:

=SUMPRODUCT(--(TEXT($A$2:$A$14,"mmmyy")=TEXT(E1,"mmmyy")))

this is for month and year match

[sweep]

or,

=SUMPRODUCT(--(MONTH(A2:A11)=MONTH(E1)))

[avidcat]

Thanks! Works great.

[NBVC]

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