Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to sum columns or rows in Google Sheets.
How to Sum Columns or Rows in Google Sheets
Adding up rows or columns of numbers is a very common operation carried out in any spreadsheet program, and Google Sheets is no exception. There are several ways to quickly sum the numbers in a range of cells.
In this guide, we’ll show you how to sum rows and columns in Google Sheets using the AutoFill tool and the SUM function.
How to Find the Total of a Column or Row in Google Sheets
Here’s how to find the total of a row or column in Google Sheets.
Select a cell where you want to output the sum of your row or column.
In this example, we want to output the sum of the range A1:A11 in cell A12.
Next, we’ll use the SUM function with our target range as the sole argument.
We can use the AutoFill tool to find the totals of the remaining columns.
We can also use the SUM function to find the sum of a given row.
We can then use the AutoFill tool to find the sum of the remaining rows.
We can also find the sum of a column or row using the Summarize feature. First select the row or column you want to find the sum of.
Next, click on the dropdown menu seen in the bottom-right corner of Google Sheets.
There should be an option that shows the sum of the currently selected row or column.
This method is best for when you only need a quick assessment of the sum without needing to keep the value in your sheet.
This guide should be everything you need to sum a column or row in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula