Adding some cells or a column is some of the most common things users do in Google Sheets.
If you have a column full of numbers, you can easily calculate the sum of the entire column (or a specific range in the column).
Follow along with this Google Sheets sum of column guide to master this function.
Google Sheets SUM Formula Syntax
The syntax for the SUM formula in Google Sheets goes as follows:
=SUM(value, [value2], ...)
- =SUMÂ is the function name to let sheets know the type of calculation to make
- value is the only necessary argument for the function to work (we’ll go through some examples)
- A comma must be between each value to signify there is a new value
- [value2]Â is another argument you’d like the sum formula to consider
Quick Examples of SUM Formulas
To SUM a single range of cells you could use a formula such as this:
=SUM(A1:A13)
To SUM multiple ranges, here’s an example of how to add up a column in Google Sheets with another range:
=SUM(A1:A13, B1:B13)
To SUM single values, you can put individual cells as the value arguments, like so:
=SUM(A1, B1, C5, C15)
You could also use a combination of single-cell values and ranges, here’s how to add up numbers in Google Sheets from multiple ranges.
=SUM(A1:A13, B1:B13, C5, C15)
A Step by Step Guide on How to Do SUM on Google Sheets
Step 1: Select an empty cell to perform the calculation in
Step 2: Type =SUM( into the cell
Step 3: Click and drag over the cells you wish to sum, or type the range manually
Step 4: Press Enter
How to Sum a Column in Google Sheets With the Sum Function
Suppose you have the dataset as shown below and you want to get the sum of all the values in the column.
Below is the Google Sheets sum column formula that will give you the sum of all the values:
=SUM(A2:A10)
Enter this formula in cell A15 (or whichever cell where you want the sum of the column) and hit the enter key.
Google Sheets try to guess the range for you which you want to calculate the sum. When you enter the text =sum and then hit the tab key, Google Sheets will automatically select the range of cells that have the numbers.
Since this is a dynamic result, in case you change anything in any of the cells, the formula would automatically update.
While this works great, what if your data expands and you get new values that you need to be a part of the sum. While you can adjust the formula, there is a better way to make the formula dynamic.
Instead of just using the range that has the values, you include more cells that might get some additional data in the future.
In our SUM Google Sheets example, I can use the below formula instead:
=SUM(A2:A14)
Although cell A11 to A14 are empty as of now, these are still used in the formula. In case a value is added to these cells, the formula would automatically update to reflect these new values in the total sum.
Sum an Entire Column Using the SUM Function
Another thing you can do when calculating the sum of all the values in a column is to include the entire column as a part of the formula.
For example, suppose you have the data as shown below and you want to add all the values in the entire column. At the same time, you want to make sure that in case any new value is added anywhere in the column, it’s also added to the total value.
Below is the adding columns in Google Sheets formula that will do this:
=SUM(A:A)
The above formula takes A:A as the input range, which represents the entire column.
Also, don’t worry about having any text value in the column, as text values are automatically ignored.
Note: For this to work, you need to enter the formula in a cell that is not in the same column. If you keep it in the same column, it would give a reference error as there would be a circular reference issue.
Remember that the SUM formula only adds those cells that have a numeric value. If there is any text, or of the number that has been formatted as text, it would be ignored.
So this is how you can use the SUM formula to get the total of a column in Google Sheets
I hope you found this tutorial useful!
How to SUM a Row In Google Sheets
You can use the above method for rows too. You just have to use the cell references for the row instead of the column, like so:
As you can see it works exactly the same as columns with cell references. It works the same if you want to SUM the entire row too. You must make sure the cell performing the calculation is not in the same cell to avoid a #REF! error.
Using the Function Button Instead of Typing Formulas
You can use the functions button instead of typing the SUM function. Here’s how:
- Select the empty cell to perform the calculation in
- Click the Functions shortcut
- Click SUM
- Click and drag over the range
- Press Enter
How to Use the SUM Function in Google Sheets Mobile
You can use the SUM function in exactly the same way as you do on the desktop version. Here’s how to total a column in Google Sheets Mobile:
- Select an empty cell
- Type =SUM(
- Enter the range(s) or cells to sum or press, hold, and drag over a range
- Type a closing bracket )
- Tap away onto another cell
Google Sheets SUM of Column FAQ
How Do I SUM a Column in Google Sheets?
Here’s how to sum cells in Google Sheets:
- Select an empty cell
- Type =SUM( into the cell
- Click and drag over the cells you wish to sum, or type the range manually
- Press Enter
How Do You SUM an Entire Column?
To sum an entire column you just have to use the column name as the value argument for the SUM function. For example, to sum the column C you could use this formula:
=SUM(C:C)
Keep in mind that the cell you perform the calculation in can’t be part of the column
How Do I SUM a Row in Google Sheets?
Summing a row works exactly the same as columns, here’s how to sum in Google Sheets using rows as an example:
- Select an empty cell
- Type =SUM( into the cell
- Click and drag over the cells in the row you wish to sum, or type the range manually
- Press Enter
The final formula could look something like this:
=SUM(A1:F1)
How Do You SUM Multiple Columns in Google Sheets?
You can add as many columns or ranges as arguments to the SUM formulas as values as you’d like. You just have to separate them with a comma. Let’s pretend you want to SUM the values of the entire A and B columns and rows 3-5 in column C, you formula would look like this:
=SUM(A:A,B:B,C3:C5)
Final Thoughts on How to Add up a Column in Google Sheets
The SUM function is one of the simplest formulas to use in Google Sheets once you get the hang of it. And, when you’ve had enough Google Sheets sum of column practice, you’ll feel more comfortable tackling difficult formulas. There’s still plenty more to learn about spreadsheets. Check out some of the below guides to increase your knowledge.
Other Google Sheets tutorials you may like:
- How to Multiply in Google Sheets (Numbers, Cells or Columns)
- Easy Guide: How to Subtotal in Google Sheets
- How to Divide in Google Sheets (Numbers, Cells, or Columns)
- How to Merge Cells In Google Sheets
- How to Apply a Formula to an Entire Column in Google Sheets
- Slow Google Sheets? Easy Ways to Speed Up
- How to Compare Two Columns in Google Sheets
- How to Use SUMIF function in Google Sheets? Examples!
4 thoughts on “An Easy 4 Step Google Sheets SUM of Column Guide”
Hey, so I added a net worth column to mine. Simply copy over a column then clear it and type “=SUM(D12:I12)”. I think it’s a neat idea maybe you could edit your chart.
Nice, helpful post
For sum reason this formula does not seem to work for me. Even though I have all values greater than 0, it sums them up to 0.
You may be selecting an empty cell with a null value.