Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #561 May 26, 2012 www.energyefficientbuild.com.
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
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
No comments:
Post a Comment