Formula summing data between two dates

[barefoot152]

I'm looking for a formula that will sum data in a range based on a certain date range.

For example. I have a project that is starting on 1/1/08 and lasting 24 months so the end date would be 12/31/09. I need to add all the costs in 2008 and then in a seperate cell add all the costs in 2009. I need the formula to be able to adjust with the beginning date. Sof if the starting date is 6/1/08 and ends 6/30/10 I need the formula to be able to handle that.

Any help would be greatly appreciated!

[VBA Noob]

Sumproduct should work

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

Lots of examples on forum. Just search dates and sumproduct.

If you want someone to provide a formula post a sample file

VBA Nobo

[barefoot152]

What i'm looking for is attached in the excel file. What would be the sum for 2008 based on the start date?

[VBA Noob]

Does this help

=SUMPRODUCT(--(YEAR($A$5:$A$40)=YEAR($B$1)+(ROW(A1)-1))*($B$5:$B$40))

VBA Noob