Tuesday, February 26, 2013

yogi_Compute Running Average Of Numbers In A Column


                                          Google Spreadsheet   Post  #1048
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 26, 2013
user Jamie Greenberg said:(http://productforums.google.com/forum/?zx=d9dujze9rels#!category-topic/docs/spreadsheets/ybNa-0e_kGk)
Autofill Spreadsheet cells with Formula Question
Hi everyone.  

I'd like to display a "running average" in one column of my table, so each cell in that column would have the following formula:
=AVERAGE(D2:D2)
=AVERAGE(D2:D3)
=AVERAGE(D2:D4)
...etc.

I was under the impression that if I manually entered the first few rows, selected them all, and then dragged the mouse downward through the remaining columns in my table...it would correctly keep the "D2" field the same and increment the "DX" field as appropriate. Instead it seems to be incrementing both fields, so I have to go in and manually fix each row. Is there any way to do what I want with less manual work? In this example it's not a huge deal....but as the formula's get more complicated (and reference a static constant that's stored in a specific cell elsewhere in the spreadsheet, it becomes a huge hassle.

What am I doing wrong?
---------------------------------------------------------------------------------------------------------
following is a solution to the problem