The easiest way to add a total for a column or row of numbers in Excel is by using the AutoSum feature.
Summing Numbers Using AutoSum
To quickly sum a series of numbers in Excel, follow these simple steps:
- Select a cell next to the numbers you want to sum. This cell is where the total will appear. If you want to sum a column, select the cell directly below the last number. If you want to sum a row, select the cell directly to the right of the last number.
- On the Home tab in the Excel ribbon, find the Editing group.
- Click AutoSum. Excel will automatically detect the range of numbers above or to the left of the selected cell and propose a SUM formula (e.g.,
=SUM(A1:A5)). - Press Enter. Excel will calculate the sum of the selected range and display the total in the cell you chose.
This method is quick and efficient for adding up columns or rows of data without manually typing formulas.
Example
Let's say you have the following numbers in cells A1 through A5:
| Item | Amount |
|---|---|
| Item 1 | 10 |
| Item 2 | 15 |
| Item 3 | 20 |
| Item 4 | 5 |
| Item 5 | 25 |
| Total |
To get the total in cell A6:
- Select cell A6. This cell is next to the numbers in column A (specifically, below them).
- Go to the Home tab and click AutoSum. Excel will propose
=SUM(A1:A5). - Press Enter. Cell A6 will display
75.
Using AutoSum simplifies the process, letting Excel handle the formula creation for you.
