How To Sum A Column In Google Sheets

Do you have a long list of numbers in Google Sheets that you need to add up? Instead of manually adding each one, Google Sheets offers a simpler and quicker method. In this tutorial, we will guide you on how to sum a column in Google Sheets.

Step 1: Select the cell where you want the total sum to appear

Firstly, click on the cell where you want the total sum to be displayed. This is usually at the bottom of the column you want to sum.

Step 2: Enter the SUM function

After selecting the cell, type =SUM into that cell.

Step 3: Input the range of cells to be summed

Next, you will input the range of cells you want to sum. This will look something like (B2:B100), where B2 is your starting cell and B100 is your ending cell.


Press Enter after you’ve input your range.

Step 4: The SUM of the column appears

Once you’ve pressed Enter, you’ll see the sum of the numbers in your column appear in the cell where you typed the formula. Now, any time you add a new number in your column, this total will automatically update.


Google Sheets makes it incredibly easy to perform calculations on large sets of data. By learning to use the =SUM function, you can add up columns of numbers with ease. We hope this guide has been helpful. Happy calculating!