Sumif using dynamic date criteria

Hi all!

I have class dates in column B. I have number of students in column C. In cell G1 I have the month & year (Aug-2005, Sep-2005, etc). I'm trying to sum all of the students by month beginning in cell G2.

I'm headed down the path of SUMIF((month(B:B)&year(B:B),(MONTH(U1)&YEAR(U1)),C:C) but that formula is not working. Any ideas to point me down the right path? Thanks!

Brian

Brian,

Try,

=SUMPRODUCT((MONTH(B1:B3)=MONTH(G1))*(YEAR(B1:B3)=YEAR(G1))*C1:C3)

Adjust your ranges as needed. Note: You can not use entire column references (A:A, B:B etc...) with SUMPRODUCT and your ranges have to be the same size.

HTH

Steve

That worked! Thanks a ton!!!

You're welcome. Thanks for the feedback.

Steve