SUM values between dates

[Guest]

I have 2 columns D736 and E7:36
Column D contains dates ie: 9/7/2004
Column E contains a value ie: 2
In another cell I would like to add the values for column E if the
corresponding row in D is in the month of September 2004.
Any help would be great.

 

[JulieD]

Hi

one option

=SUMPRODUCT(--(D136>=DATEVALUE("9/1/04")),--(D136<=DATEVALUE("9/30/04")),E1:E36)

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for more details on the sumproduct function

Cheers
JulieD