Knowing how to add and sum is fundamental when it comes to working with Excel. In our previous blog “How to add”, we guided you through basic ways to add numbers, cells, and columns. We also mentioned the basics of the Sum formula. In this tutorial, we are going to cover other methods known as AutoSum and the SUM function.
How to use AutoSum to add in Excel
Basically, if you want to add adjacent cells, columns, or rows, you can use AutoSum which is the quickest way.
How to total a column in Excel
Here is how you use AutoSum to add the values in a column:
- Click on the cell below a column of adjacent cells
- Go to the Formula tab, click on AutoSum
- Press Enter, Excel adds all of the adjacent cells
In the screenshot below, cell B15 is the last cell below the column.
How to sum a row in Excel
As mentioned above, you can add the values in adjacent rows, as well.
- Click on a cell right of the row of adjacent cells
- Click on AutoSum by going to the Formula tab
- Press Enter and the cell displays the results
If you look at the screenshot you can see that cell F13 is the last cell to the right of the row.
You can also find AutoSum by clicking on the Home tab in the Editing section. The shortcut for AutoSum is [Alt+=].
How to get the grand total in Excel
If you want to get the sum of the rows and columns, including the grand total, follow the steps below.
- Select a group of adjacent cells and an extra (blank) column and row.
- Go to the Home tab in the Editing section.
- Click on AutoSum and get the sum of the rows and columns, including the grand total in the extra column and row you have selected.
Bear in mind, if you update any of the cells with new values or figures, AutoSum will automatically update the results in each row and column, including the grand total. You can compare the screenshot below with the one above to see how the data updates have changed the AutoSum results.
How to use the SUM function in Excel
The SUM function in Excel is another option for adding values. Remember that a function is just a predefined formula. You must also be aware that you can use up to a total of 255 individual arguments. These arguments include numbers, cell references, ranges, arrays, and constants, or a mix of all.
Here is a simple example which shows how the SUM function works.
- Click on an empty cell where you want to see your SUM function results.
- You can either start with typing =SUM( manually, or as you start typing =SUM you will see a box appear below the cell, double click on SUM or press Tab, and the formula will appear.
- Now that you have the formula, hold down the Ctrl key, select the range of cells you want
- Press Enter to finalize the function and see the results
Again, if you look at the screenshot, you can see the range of cells that are selected in the cell and in the formula bar. In the next paragraph, you can check out the description provided for the SUM function formula.
This SUM function starts with an = sign, then the SUM function, open parenthesis, then the first range of cells, E13:E14 (this is the number1 argument in the SUM function), then a comma, then the next range of cells, E9:E10 (this is the number2 argument in the SUM function), and then the last cell reference E3 (this is the number3 argument in the SUM function), then the closing parenthesis. The next screenshot demonstrates the final result.
- Now that you have the results based on the SUM function, you can fill in the adjacent cell with the same formula, so you click on the cell that has the results and point your cursor to the right-bottom corner and it will change to a black sign. Now, press hold and drag towards the adjacent cells you want. Take a look at the screenshot below. Remember, this is just an example to show you how the formula works.
In the screenshot, as you can see, by dragging the cursor, the row to the left of cell E15 is selected.
Next, after releasing the mouse, the same formula is placed inside the selected cells and you can see the results.
Let’s check the formula of the adjacent cells and compare it with column E; the same formula is reproduced. You can also perform the same for rows.
I hope you found this blog helpful. If you need to know more about other Formulas and Functions, check out our other blog on “How to Calculate Average in Excel” and “How to Subtract in Excel.”
To get a better insight on our Excel services check out Microsoft Excel Consulting Team and Excel Support.