Moving average of the last 13 cells in a row

[sacorndog]

Hi everyone,

I need to calculate the moving average of the last 13 cells in a row. Every week I will add another row to the data.

Example:

The 13 week Average displays in A1

The data is added as follows:
Week 1 data is in A2
Week 2 data is in A3
....
Week 15 data is in A16

What would my formula be so that every week I added a new row it would update to show only the average of the last 13 weeks?

Thank you very much for all your help. It is very much appreciated.

Kindest,
M

[modytrane]

Here's one way to do it without macros.
Column A and B are used as helper columns.
You can unhide them to see the formulas.
Cell C1 shows average of last 13 entries in column C.
Hope this helps.
modytrane

[DonkeyOte]

Assuming the data points are contiguous in nature and numeric then based on interpretation:

Please Login or Register  to view this content.

modify ranges to suit