Saturday, May 26, 2012

yogi_Compute Average Of A Growing Set of Numbers In A Range Row By Row

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #561    May 26, 2012

user Trillium said:
Infinite average
I am trying to create a total percentage using averages. however i do not want to continue changing the formula to coincide with the number of entries. i want the formula to add all of the entries as they are added. for example lets say i have 5 entries. i have (1+1+0+1+0)/5 to give .60 or 60%. yet if i added a cell it would be (1+1+0+1+0+1)/5 instead of being divided by 6. how do i get the formula to recognize the added cell and account for it in the division of total numbers. also how do i get the formula to ignore blank cells in the total number of cells
following is a solution to the problem