12 month rolling in excel

[rentras]

Please can anyone tell me how to calculate 12 month rolling in excel? I have the data for 12 months, and i need to calculate 12 month rolling. Not sure how.Thanks

[mrice]

Please see the attachment for an example. Copying the formula in column C down gives the average of the last 12 months.

[rentras]

thank you! But what if we have only 12 month of data? That is, Jan 09 to Dec 09, then for Dec 09 we will do average of 12 month, but for Jan will be 11 month average, feb 10 month average, march 9 month and so on. Right?

[mdbct]

Using the same workbook-(entered in row 1 and copied down):

Please Login or Register  to view this content.