Hi there.  I have a spreadsheet where columns B1 – S1 are labeled week1, week2, week3, etc. up to week 18. In column B2 – S2, I am entering weekly percentages.  So, having just completed week2, column B2 has a percentage of 41.4 and column C2 has a percentage of 59.6, while columns D2 – S2 are empty at this point.  I want column T2 to display the average to date.  So, after week two, it would display the average of 41.4 and 59.6, which would be 50.5.  However, when I enter a week 3 percentage in D2 (say 64.0), I would then want the new average (55) displayed in column T2.  Since some columns will always be empty until after week 18, I’m not sure how to compute the weekly averages after new percentages are entered each week.  Thanks in advance for your help.   

​Hi there.  I have a spreadsheet where columns B1 – S1 are labeled week1, week2, week3, etc. up to week 18. In column B2 – S2, I am entering weekly percentages.  So, having just completed week2, column B2 has a percentage of 41.4 and column C2 has a percentage of 59.6, while columns D2 – S2 are empty at this point.  I want column T2 to display the average to date.  So, after week two, it would display the average of 41.4 and 59.6, which would be 50.5.  However, when I enter a week 3 percentage in D2 (say 64.0), I would then want the new average (55) displayed in column T2.  Since some columns will always be empty until after week 18, I’m not sure how to compute the weekly averages after new percentages are entered each week.  Thanks in advance for your help.     Read More

​