Excel Autosum

AutoSum includes easy access to the five most commonly-used functions in Excel: 

• SUM – Adds all the cells in a range
• AVERAGE – Finds the average (SUM / COUNT)
• COUNT NUMBERS – Displays the number of cells that contain numbers
• MAX – Displays the highest value in a range
• MIN – Displays the lowest value in a range

There are three primary methods available to enter a function:

1. Autosum
2. Insert Function button
3. Directly type the function into the cell

How to use Autosum:

1. Select the cell where you want the calculated value to appear
2. HOME >> Editing group >> Autosum
3. Select the function desired
4. Verify the range automatically selected and re-select the correct range if necessary
5. Press the Enter key

How to use the Insert Function method:

1. Select the cell where you want the calculated value to appear
2. Click on the (fx) button and select the category from the drop-down list
3. Select the function 
4. Complete the dialog box by selecting the appropriate ranges
5. Press the Enter key

This method is useful if you are not sure which function you need since the description appears below as you click on each in the list.

How to directly type the function into the cell:

1. Select the cell where you want the calculated value to appear
2. Type “=”
3. Then, proceed to type the name of the function
4. While typing, a dropdown list will appear, which displays all of the functions that have the same letter combinations as the ones you have entered so far
5. To select a function from the dropdown, select the name and hit the “TAB” key, or double click with the mouse (just single click for Mac)
6. Proceed to enter the inputs required by that function

Continue Learning Excel

Practice spreadsheet skills in Excel classes, explore Microsoft Office training, or discuss training for your team.