Sunday, March 10, 2013

yogi_Compute 3 Month (current month and prior two months) Rolling Average Of Specified Metrics

                                          Google Spreadsheet   Post  #1078
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Mar 10, 2013
user David LaLande :(!category-topic/docs/spreadsheets/pN8t5vketRI)

I need some help with a formula for a 3 month rolling average.  I've tried it a couple different ways but I can't get it right.  Any help would be appreciated.

Here is my sheet.

Thank you,

I have values in the first three rows of column C starting at C2.  I am trying to do a rolling 3 month average of column C.  I'm not getting it done.

following is a solution to the problem