Trying to work out averages from only last 12 entries

[Speedbird1]

Good Morning,

Every month i get paid. If i do something different from my own job during the month i get paid average pay as opposed to regular basic pay. Average is worked out by taking total earning including everything for the previous 12 months, dividing it into weeks then dividing it again into days (currently 5 a week)

If i imagine A1:L1 contains my monthly gross figures, what calculation is required in M1 to show my daily average? ( i can do this bit without too many issues)

Bearing in mind "next month" it's monthly figure will be entered into an "inserted column" which will then become M1 so the calcs in M1 currently will become N1 and so on each and every month.( so, the calc needs to reflect B1:M1 The following month needs to reflect C1:N1 and so on).

The calculations in what is currently M1 and next month N1 and so on need still to count only the previous 12 month's figures.

I hope that makes sense and someone may be able to assist me with this problem as i can't make it work.

Finally, if there is a simpler way to lay this out rather than just keep getting longer and longer across the sheet then i would definately listen.

Thank you

Mike

[dilipandey]

Hi Speedbird,

I guess, you can achieve this using defined name.. please upload a sample workbook so that I can give it a try. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Speedbird1]

@Dilipandey
thank you but i have not yet managed to work out a sheet to send. I have not yet managed to create one yet.

Sorry

[Speedbird1]

I think i have posted this query in the wrong section.

Consider this closed and replaced into "formulas" section