How To Add Up A Column In Google Sheets

Google Sheets, Google’s online spreadsheet app, is a powerful tool that you can use to organize and analyze data. It offers a wide range of functions, including the ability to add up a column of numbers. Here’s a step-by-step guide on how to do this.

Step 1: Open Google Sheets

Navigate to Google Sheets and either open an existing spreadsheet or create a new one.

Step 2: Add Your Data

Enter your data into a column in your sheet. It doesn’t matter which column you use.

Step 3: Use the SUM Function

At the end of the column (or anywhere else you’d like to see the total), click on an empty cell and type =SUM(. After typing =SUM(, click on the cell at the top of the column you want to add. Then, drag the mouse or touchpad cursor to the bottom of the column to select all the cells you want to add.

Step 4: Close the Parenthesis

Close the parenthesis for the SUM function by typing ). So the formula will look something like =SUM(A1:A10). Here, A1 and A10 represent the range of cells in column A that you want to add up.

Step 5: Press Enter

Press Enter and Google Sheets will calculate the sum of the column and display the result in the cell where you typed the formula.

Your Google Sheets screen should look something like this:

Google Sheet screen

Example using the SUM function


In this example, =SUM(A1:A10) adds up all the numbers in cells A1 through A10.


Adding up a column of numbers in Google Sheets is relatively simple once you know how to use the SUM function. As you can see, Google Sheets can be a very powerful tool for calculating and organizing data, once you know how to use it.