How to Sum Columns or Rows in Google Sheets

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.


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.