I have a spreadsheet recording monthly sales over several years.

I can easily sum these and find the average sales per month but what I would
like to be able to do is find the sum or average of just the last twelve.
Again this is easy if I am prepared to edit the average formula each time I
enter a new monthly figure but I should like to automate this.