how to insert an Excel table in Word
Share on facebook
Share on twitter
Share on pinterest

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.

using autosum to add up a column in excel
AutoSum of a 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. 

using autosum to add up a row in excel
AutoSum of a row

You can also find AutoSum by clicking on the Home tab in the Editing section. The shortcut for AutoSum is [Alt+=].

autosum is in editing in home tab in excel
AutoSum in home tab

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.  
using autosum to sum and get the grand total of adjacent group of cells in excel
AutoSum adjacent group of cells

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.

updating the data in the group of adjacent cells and getting the sum and grand total update in excel
autosum of a adjacent group of cells update

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. 
how to use the sum function in Exce
typing the sum function
  •   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.

how to select the range of cells when adding using sum function

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.

the sum of selected cells using sum function
result of sum function
  •  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.

General Info TypeImage Dimensions‪508 x 410‬ Size17 KB Location Modified9:19 PM Dec 18 Created8:00 PM Apr 1 Opened by me9:19 PM Dec 18 Sharing S Shakiba Divandari Can Edit Hajir H Can Edit S Sajad Seifian Can Edit Ahmad Dabiri Nejad Can Edit M Monire Ghasemi Can View Paria Sharifian Can View A Aria Arian Can View K Kamyar Mirzaei Can View R reza hosseini Can View Sara Darvishi Can View Fatemeh Sameri Can View Mehrdad Mozafari Can View V Vida Nour Can View A Ahmad Mohammadi Can View Afrooz Hajian Can View Hamid Ganji Can View Mohsen Sadeghzade Can View Ava S Can View M Maryam Arasteh Can View Ardeshir Behbood Can View Khosro Vahedi Can View A Sharifian Can View F Fereydoon Ghanbarnejad Can View Bahare Divandari Owner Description how to replicate the formula in adjacent cells
tip for sum function

Next, after releasing the mouse, the same formula is placed inside the selected cells and you can see the results.

the result of sum function based on the replicated formula
results of replicating sum function

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.

the formula bar shows the sum function formula
check the results

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. 

Subscribe to our Newsletter

Share this post with your friends

Share on facebook
Share on google
Share on twitter
Share on linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *