Want to learn how to sum a column in Google Sheets? The easiest way to sum a column in Google Sheets is to use the SUM function.
To do this, you type =SUM()ย and put the column or range inside the brackets.
For example, if I wanted to get the total of the entire column A, I would type =SUM(A:A).
If I wanted to sum a range within a column, it would look more like =SUM(A1:A12).
Confused? Donโt worry; my step-by-step article will show you exactly how to do it. So, follow along, see the screenshots with examples, and within five minutes, youโll use the SUM function to manage your datasets! Letโs get started.
Table of Contents
How To Sum a Column in Google Sheets
Adding some cells or a column is among the most common things users do in Google Sheets. You can use multiple functions to add up a column in Google Sheets, including the SUBTOTALย and SUM functions.
Hereโs how to make Google Sheets add up a column.
- Type the equalsย sign (=) into the cell you want to return the total.
- Type SUM(.
- Select the range you want to add up and press “Enter.“
For example, here is an example of the SUM formula for a column in Google Sheets:
=SUM(A1:A11)
The GIF below shows the sums of the cell numbers from A2 to A11. It will not update with this formula if you want to add information beyond those cells.
How To SUM an Entire Column in Google Sheets
The best way to sum up a column in Google Sheets is to use a formula encompassing the whole column instead of just a range. Here’s how to add all numbers in a column in Google Sheets:
- Type the equalsย sign (=)ย into the cell you want to return the total
- Type SUM(
- Select the column header or type the columnโs name (A:A for column A as an example)
- Press “Enter“
Here is what a full formula summing Column A would look like:
=SUM(A:A)
As you can see in the example above, I can add additional information later. I added numbers beyond cell A11 without updating the SUM function column. It automatically incorporates those new numbers because the syntax accepts all numbers within my chosen column.
Note: For this to work, you must enter the formula in a cell, not in the same column.ย Keeping it in the same column will give a reference error, as there would be a circular reference issue.
Using Autocomplete
Google Sheets is a smart program that often suggests the range as you type. If it looks correct, press โEnterโ instead of continuing to type.
How To SUM a Column in Google Sheets: Syntax
One of my favorite ways to review a function in Google Sheets is to examine its variables. For example, here is the syntax for the SUM formula in Google Sheets:
=SUM(value, [value2], ...)
The Google Sheet sum formula is pretty simple, especially when you break down the components:
- =SUM: This indicates the function name. It informs Google Sheets about the type of calculation to make.
- Value: This represents the necessary argument for the function to work (I’ll walk you through some examples below to give you a better understanding)
- A comma: This is an essential component and must be included between each value to signify a new value.
- [value2]: This is optional in the Google Sheets formula for the sum of a column. It is only used when adding another argument to the SUM formula.
How To SUM Multiple Columns in Google Sheets
Usually, the first two examples I gave you at the beginning of the article will be enough to finish the Google Sheets SUM of column answers you need in your spreadsheet. But, if you need to sum multiple columns or a range of cells, youโll need more explanation.
How To SUM Multiple Ranges
To SUM multiple ranges of data,ย you can specify the two ranges with a comma in between.
Hereโs how to get theย sum of twoย columns in Google Sheets:
- Type =SUM(ย into an empty cell.
- Type or click and drag to select the first range of cells.
- Type a comma.
- Type or click and drag to select the second cell range and put a closing parenthesis.
- Press โEnter.โ
Hereโs an example of what a formula to sum multiple ranges would look like
=SUM(A1:A13, B1:B13)
How To Sum Single Values
You can also add numbers using single values.
- Type =SUM(ย into an empty cell
- Click each cell you want to include and type a comma between each click.
- Add a closing bracket and press Enter
Note: You can also type values instead of cell references, like in the example formula below
=SUM(A2, B2, C5, 15)
How To SUM Multiple Ranges and Single Cells
You can combine or sum ranges or single-cell values to merge your data. You have to use what you learned from the last two examples. Here’s how to add columns in Google Sheets from multiple ranges:
- Type =SUM(ย into an empty cell.
- Click and drag over each range you want to include with commas between each.
- Repeat the previous steps with individual cells.
- Add a closing bracket and press โEnter.โ
=SUM(A1:A13, B1:B13, C5)
Don’t miss this 2-minute video on how to sum a column in Google Sheets! By the end of the short video, you’ll feel more confident using the SUM function!
[adthrive-in-post-video-player video-id=”9hw41j6Y” upload-date=”2023-12-05T14:22:22.000Z” name=”How to Sum a Column” description=”Here’s how to sum a column in Google Sheets. I show how to do a partial column and the whole column in this short video. It uses the SUM function.” player-type=”default” override-embed=”default”]
How To Get Google Sheets to Add up a Column Using the Status Bar
You can also find the sum of a column without using a formula. All you need is theย status bar, which adds the numbers in a range to display the cell value in which you have built your formula.
To find the sum of a column using the status bar, follow the steps below:
Step 1:ย Select the data range
Step 2: Click on the status bar at the bottom right corner of the screen.
Step 3:ย Youโll find the options Sum, Average, Min, Max, and Count. Select “Sum.”
This will show you the sum of the data in the column and allow you to keep a consistent running total in Google Sheets. However, it wonโt return the results to any cell in your spreadsheet.
How To SUM Rows In Google Sheets
You can use the above method for rows too. You have to use the cell references for the row instead of the column, like so:
As you can see, it works the same as columns with cell references. It also works the same if you want to sum the entire row. For example, to sum up Column B, you would use B:B as the criteria. Similarly, to learn how to sum the column in Google Sheets, use 1:1 as the argument, like in the example below.
Remember, youย must ensure the cell performing the calculation is not in the same cell to avoid aย #REF! Error.
Using the ฮฃ Function Menu Instead of Typing Formulas
An alternative shortcut to find the total value of a column is to use the functions button instead of typing the SUM function. This can improve your navigation and efficiency because it eliminates the need for manual input.
Follow these steps to learn how:
- Select the empty cell to perform the calculation.
- Click the ฮฃย function shortcut.
- Click SUM.
- Click and drag over the range or type the range.
- Press โEnter.โ
How To Sum a Column in Google Sheets with Text
If youโre considering combining two pieces of text into one value using the addition operator or the ADD function, expect Google Sheets to display the wrong formula. This is because it doesnโt work like Python, a coding language that allows you to add two strings with a plus sign (+).
Instead, you may want to check out the CONCAT and CONCATENATE functions when combining texts in a spreadsheet. To learn more about these functions, read our tutorial on How to Append Text to Each Cell in a Column in Google Sheetsย to learn more about adding strings.
How To Sum a Column in Google Sheets on a Mobile Device
You can also perform most of the functions in the Google Sheets mobile app, including the Google Sheet sum of a column function.
Here’s how to sum a column in Google Sheets using the mobile app:
- Tap the cell where you want the results.
- Tap “Enter” text or formula to display the keyboard.
- Type the SUM formula into the text box.
- Select the cells in the column you want to add up.
- Once you’re done, tap the checkmark.
The formula will return the sum of the column selected in the cell.
How to Add Numbers in a Column or Row Individually in Google Sheets
If you need to add cells together, you can also try inputting the two numbers you want to add into separate cells. Then, you can use the addition equation to give you the correct sum.
Follow the steps below to learn how to do it:
- In the first cell, put your first addend.
- Then, select another cell and place the second addend.
- Next, click another cell and input the following syntax:
=B2+C2
- After that, press โEnterโ or โReturnโ to see your results.
Your sum will automatically change as you modify the addends entered in your cells. This way, you can create a foolproof formula while using an automatic calculator.
What Does the SUM Function Do?
In my article on how to add in Google Sheets, this process relies on the SUM function. If you havenโt read the article, here is a simple recap.
When you use the SUM function in Google Sheets, it returns the sum of all the numbers in the column into the cell. Google Sheets will predict the SUM formula for you as a suggestion. These guesses are often correct, but it is always worthwhile for you to double-check the data to ensure there are no mistakes.
Get Our Premium Templates
If you canโt be bothered continuing to learn how to navigate Google Sheets, we likely have the perfect template for you to use instead. Check out our extensive range of premium templatesย by clicking the button below. And donโt forget to use the discount code SSP for 50% off.
Final Thoughts on How To Sum a Column in Google Sheets
The SUM function is one of the most straightforward formulas to use in Google Sheets once you get the hang of it. And, when you’ve had enough Google Spreadsheet sum of column practice, you’ll feel more comfortable tackling complicated formulas.
Now you know how to sum a column in Google Sheets. But there’s still plenty more to learn about spreadsheets. Check out some guides below, or consider taking a spreadsheet courseย to increase your knowledge.
Related:
- How To Multiply in Google Sheets (Numbers, Cells, or Columns)
- 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
8 thoughts on “How To SUM a Column in Google Sheets (5 Minute Guide)”
How do I do this with words instead of numbers?
Are you looking to concatenate words? If so, that’s covered here: https://spreadsheetpoint.com/concatenate-google-sheets/
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.
I use an =IF formula to automatically add the numbers I want into a cell.
=if(B2>=8, “0.2”,”0″)
I try to sum up every column at the end with =SUM(F2:F32) but it doesn’t do it, just gives me 0. I thought it would add the numeric values but apparently not. Anyone know a way to do it?
I think it’s the quotes. Remove those and you should be ok.
=IF(B2>=8, 0.2, 0)