M
Marena
I have a series of monthly dates formatted as 01/01/2006, 02/01/2006, etc. to
most recent data point in column A. In column B I have data. In column C I
would like to calculate a rolling YTD number that is the sum of the YTD data
from this year (based on the latest data point/date that is populated in
column B) and divide this by the sum of the previous year's similar YTD sum.
(i.e. if the latest data point is for 03/01/2008, the calculation would be
(03/01/08 data +02/01/08 data + 01/01/08 data)/ (03/01/07 data +02/01/07 data
+01/01/07 data). I have been working with OFFSET and COUNTA, but I am
definitely not there. Any help would be greatly appreciated.
most recent data point in column A. In column B I have data. In column C I
would like to calculate a rolling YTD number that is the sum of the YTD data
from this year (based on the latest data point/date that is populated in
column B) and divide this by the sum of the previous year's similar YTD sum.
(i.e. if the latest data point is for 03/01/2008, the calculation would be
(03/01/08 data +02/01/08 data + 01/01/08 data)/ (03/01/07 data +02/01/07 data
+01/01/07 data). I have been working with OFFSET and COUNTA, but I am
definitely not there. Any help would be greatly appreciated.