A "running average" that averages only the last 8 entries?
Posted by Chris Rock on April 26, 2001 8:20 AM
I have data that is updated weekly, and I've created a column that tracks a running average. I have been changing the formula frequently to adjust which columns are included in the average calculation.
For example, Column IV, Row 2 has the Average Calculation. Today, the average was for cells S2:AB2, or ten weeks worth of data. Next week, I'll want to change that average formula to T2:AC2, because I'll be adding one more week's worth of data.
Is there any way to automatically get my average formula to average the last ten (or however many) weeks worth of data? Any combinations of IF statements? A macro?
I may be out of luck, I understand.
Row 1 contains the date.
Rows 2 through 49 contain data (volume per half hour).
Each worksheet in the workbook represents a day of the week.
Column IV (the last column in the sheet) contains the averages.