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. Besides the Amount column type Running SUM or Running Average in Cell D1. There you need to choose the option Average and then Press OK.
The AVERAGE function ignores logical values empty cells and cells that contain text.
After the data have been entered place the cursor where you wish to have the mean average appear and click the mouse button. Click on an empty cell then click on the f x symbol in the function bar above the worksheet. The AVERAGE function in Excel calculates the average arithmetic mean of a group of numbers. Select AVERAGE from the Select a function list.