30d moving average

[uqls]

Hi All,

Please can you help me .
My spreadsheet is like this (please see the attached):

1. Column A : Dates (Every day's Date):
2. Column B : Data numbers (daily value)


So i want to formular to calculate 30days moving average.

The formula must look at every in-Column A and calculate 30days moving average from the corresponding data in column B.


Many thanks

[Marius44]

HI
If I understand your intent, put in C31 =AVERAGE(B2:B31) and copy below.
HI
Mario

[TMS]

Or, in row 2 copied down:

Please Login or Register  to view this content.

This give an average for the ranges where there are less than 30 days, assuming that is required.

[Glenn Kennedy]

Or if you want a SINGLE value, that is the average of the most recent 30 days:

=AVERAGE(TAKE(FILTER(B2:B1000,B2:B1000<>""),-30))

change the 1000 (red) if needed.

[TMS]

If you want to ignore the zeroes in the first few cells

Please Login or Register  to view this content.

[uqls]

Thanks everyone

[TMS]

You're welcome. Thanks for the rep.