In this tutorial, you will learn how to sum columns or rows in Google Sheets.

## How to Sum Columns or Rows in Google Sheets

Quick Navigation

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.