SUMIFS with MONTH() or other similar functions

In Excel 2003, I used to achieve the results through the powerful SUMPRODUCT function to add sums with multiple criteria. Now that I have upgraded to Excel 2007, I intend to switch to using SUMIFS as it seems to be more efficient, however, I am struggling on how to replace the following formula with the new SUMIFS equivalent.

=SUMPRODUCT(--(MONTH(A7:A15)=9)*(C7:C15))

I understand the SUMIFS systax but I have not been able to find an alternative to MONTH() function within the formula. I would appreciate if someone could show me how to achive this. I have attached the Eg file for reference.

Because you are enveloping the criteria range in a function, you can't really use it as is in the SUMIFS....

This is an alternative way...

=SUMIFS(C7:C15,A7:A15,">="&DATE(2011,9,1),A7:A15,"<="&DATE(2011,9,30))

or if you want to work with only the first of the month, and let the formula determine the last day of the month, try

=SUMIFS(C7:C15,A7:A15,">="&EOMONTH(DATE(2011,9,1),-1)+1,A7:A15,"<="&EOMONTH(DATE(2011,9,1),0))