I have created a spreadsheet to forecast monthly financial results. Each
month has a projected amount, an actual, and a variance for each product.
After December, I have a total for the projected, actual and variance.
However, I would like to create a means of calculating the running variance
as I enter the actual monthlyh data. For example, the February projected
data is in column AP, the acutal is in column AR and the Variance for
February is in Column AT. I would like to be able to have a formula that
recognizes the fact that February is the most recent month for which I have
actual data and therefore totals the variance for February in Column AT w/
Column AN which has the variance for January. I would want to do this for
each month of the year. Please let me know if this requires furhter
explanation. Thank you in advance for your assistance.