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.

### Step 1

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.

### Step 2

Next, we’ll use the SUM function with our target range as the sole argument.

### Step 3

We can use the AutoFill tool to find the totals of the remaining columns.

### Step 4

We can also use the SUM function to find the sum of a given row.

### Step 5

We can then use the AutoFill tool to find the sum of the remaining rows.

### Step 6

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.

### Step 7

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.

## Summary

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:

- Addition
- Subtract
- Multiply
- Divide
- Exponents
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- 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
- Trimmean
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula