AutoSum in Spreadsheets

AutoSum displays the result of a simple calculation, such as Average or Maximum and Minimum. The following steps show how to automatically sum columns or rows with the Sum shortcut, sum a selected range vertically and horizontally in one go.

There are two locations of Autosum. You can click the AutoSum button on either the Home or Formulas tab. If you prefer working with the keyboard rather than the mouse, you can use the shortcut + to total cells.

Step 1: If you want to sum a column of numbers, please select the cell immmediately below the last number in the column.

Step 2: If you want to sum a row of numbers, select the cell immediately to the right. Like the following:

Note: Apart from adding cells, you can use AutoSum button to insert other functions, such as:

Average is to return the arithmetic mean of numbers.

Count is to count cells with numbers.

Max is to get the largest value.

Min is to get the smallest value.

All you need to do is select a cell where you want to insert a formula, click the AutoSum drop-down list, and choose the desired function from the list.