Topics Map > IT Services > Training
Topics Map > IT Services > Software Support
Microsoft Excel 2016 - Sum and Average
This guide will show you how to properly use the Sum and Average formulas, the two most used formulas in Excel.
VIDEO
Sum
The Sum formula provides the total of a certain set of cells. This is often the end-produce of the work in Excel. There are multiple ways to input the Sum formula.- In the cell where the Sum should go, type =Sum (x:y) where X represents the first cell to be added to the sum and Y represents the last Cell to be added
- In the cell where the Sum should go, type =Sum
- left-click and drag over the corresponding set of cells.
- Select the cell where the Sum should go.
- Select the Autosum tool from the toolbar.
Average
The Average formula provides the average of a certain set of cells. This is often the end-produce of the work in Excel. There are multiple ways to input the Average formula.- In the cell where the Average should go, type =Average (x:y) where X represents the first cell to be averaged and Y represents the last Cell to be averaged.
- In the cell where the Average should go, type =Average
- left-click and drag over the corresponding set of cells.
- Select the cell where the Sum should go.
- Select the Autosum drop down menu from the toolbar and select Average.
If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or helpdesk@uwosh.edu