I'm using Excel for some accounting functions but am having troubles creating a formula that will sum 12 cells given the input date.
what I have is on one spreadsheet, 24 months of data (part of '06, all '07, part '08 - one column for each month, many rows of data per column)
on another spreadsheet in the same workbook, I have Hlookups that give me the specified date's data per 1 cells date input. (Hlookups give me that 1 particular months' data, but I need more formulas for a rolling 12 months data)
If I input 1/30/08 (Jan); I need the sum of 2/1/07(Feb) - 1/30/08(Jan)
If I input 6/30/08 (June); I need the sum of 7/1/07(July) - 6/30/08(June)
Is it possible to create a formula that knows to sum 12 cells accross 1 row where the last cell summed is dependant upon the date input?
Bookmarks