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. 
  1. 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
  2. In the cell where the Sum should go, type =Sum
  3. left-click and drag over the corresponding set of cells. 
  4. Select the cell where the Sum should go. 
  5. 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. 
  1. 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.
  2. In the cell where the Average should go, type =Average
  3. left-click and drag over the corresponding set of cells. 
  4. Select the cell where the Sum should go. 
  5. 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




Keywords:"Autosum", "data entry", formula, formulas   Doc ID:65919
Owner:William W.Group:UW Oshkosh
Created:2016-08-09 14:30 CDTUpdated:2016-12-20 10:50 CDT
Sites:UW Oshkosh
Feedback:  0   0