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 A
**utosum 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