Select the Range line. There you need to choose the option Average and then Press OK. In the example shown the formula in F4 is.
In this example the source data contains data for a sales transaction on each row.
Select the Birthday Column and click the Data Filter. Calculate running SUM or running average with formula in Excel We can apply a formula to calculate the running sums or running totals easily in Excel as follows. The Excel AVERAGE function calculates the average arithmetic mean of supplied numbers. As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks.