This may or may not be an issue, depending on the structure of the worksheet, and whether it's important that all averages are based on the same number of values. If you start the formulas in the first row of the table, the first few formulas won't have enough data to calculate a complete average, because the range will extend above the first row of data: When the values are plotted in a line chart, the smoothing effect is clear: ![]() As the formulas are copied down the column, the range changes at each row to include the values needed for each average. ![]() = AVERAGE (C5:C7 ) // 5-day average = AVERAGE (C5:C11 ) // 7-day averageĪll formulas use a relative reference for the range supplied to the AVERAGE function.
0 Comments
Leave a Reply. |