Hi all

I want to be able to retrive the sum of a range of cells based on a date entered. Depending on the date entered the range of cells to sum will change.

EG: If date entered is Nov 08, then I want the sum of Jan 08 - Nov 08 data to sum so I get a Year to Date value returned.

I have a range of dates going out monthly to 2016.

EG

Jan 08 Feb 08 Mar 08......Dec 16 - (Range)
22.00 100.00 15.00

Date Entered = Mar 08

Sum = Jan, Feb and March (137.00)

If Date entered was Dec 16, it would only sum up Jan 16 - Dec 16 for a YTD value.

Appreciate any tips