Sumproduct for month

[tlindeman]

Good Morning,
I have Excel 2010, Here is my issue. In column A I have week ending dates from Jan 11 through June 2012, In column B, I have sales by week from Jan 2011 through June 2012. I built a month formula in Column C (month(A1), In column D, I have a calculation for when a week end splits a monht, i.e. if the week ends on Jan 4th, part of the week is December, part Jan. What I would like to do is something to this effect:

sumproduct(B1:B500,D1:D500) when Column C=1, For jan, then sumproduct(B1:B500,D1:D500) when Column C=2 for feb.

Thank you
Tony

 

[barry houdini]

Try using SUMPRODUCT like this for January

=SUMPRODUCT(C1:C500=1)+0,B1:B500,D1:D500)

 

[tlindeman]

Try using SUMPRODUCT like this for January

=SUMPRODUCT(C1:C500=1)+0,B1:B500,D1:D500)

Thank You I appreciate it.