Sum product or Sum if between 2 dates

[lstrutz]

I have been trying to figure out what I am doing wrong and I am at a loss.
What I need is to put the total sales for each month into the cells Jan-Dec in D53-64

For example - For January total sales:
If B3:B50 is between 1/1/10 and 1/31/10 then give me the total sales for that period from D3:D50
the formula I was trying to use is:
=SUMIF(B3:B50,"<="&DATE(1/1/10),D3:D50)+SUMIF(B3:B50,"<"&DATE(1/31/10),D3:50)

I have also tried:
=SUMPRODUCT(--(B3:B50<=DATEVALUE("1/1/10")),--(B3:B50<DATEVALUE("1/31/10")),D3:D50)

Any ideas how to do this? I uploaded the file to this link for review. I wasn't able to attach it through this thread for some reason.
http://www.sendspace.com/file/k1bpue

Thanks in advance.

[JeanRage]

Hi,

You can try :

=SUMPRODUCT(--(MONTH(B3:B6)=1)*(C3:C6))

HTH

[mubashir aziz]

Try this formula .... Although i've updated it in your file as well ...

=SUMPRODUCT(--(MONTH($B$3:$B$50)=MONTH(C53))*--(YEAR($B$3:$B$50)=YEAR(C53)),$D$3:$D$50)