Excel, creating a running average that automatically progresses

Soldato
Joined
31 May 2009
Posts
21,468
If I have two summated columns, say income and expenditure, which are created from the sum of various data that has been entered.
I can happily summate them, and then subtract one from the other, what I want to do is as each month is entered get a running total of the expenditure versus income over the past twelve months, preferably in some automated fashion, rather than having to resummate and then average the last 12 cells every single month.

Any easy method for this?
 
Sort of yes
I have columns of summed items, 2 of them, each produced each month, to do with that months figures.

What I am wondering is, if I can easily create a formula, that takes the most recent 12 figures in each column, as in 12 months income, and 12 months expenditure, and output it to a fresh column beside the two existing ones.
Its easy to add items to existing column, but I would like something that would autoupdate, so it just sums 12 items and outputs, without me having to alter the cell formula each month?
A progressive formula I suppose.
 
Back
Top Bottom