How To Add Up A Column In Google Sheets (Easy Guide)

You can add up a column in Google Sheets by using the SUM function. It is a built-in tool designed to calculate the sum of a range of cells or a whole column. To use the SUM function, start by typing the formula “=SUM(” followed by the column range, such as “=SUM(A1:A10)” and press Enter.

The Google Sheets SUM function is an essential tool for adding up a column of numbers, allowing users to easily perform calculations and manage data more efficiently. The SUM function enables quick, accurate results and can be tailored to specific ranges and columns.

Let’s see how to utilize this function to add up a column in Google Sheets.

Step-by-Step Guide to Using SUM Function in Google Sheets

Using the SUM function in Google Sheets is really simple. Here are the exact steps you need to follow.

Step 1: Open Your Google Sheets document

Access an existing document, or create a new one, and identify the column that needs to be added up.

Step 2: Choose the Cell for the Result

Click on the cell where you want the sum to be displayed, usually directly below or above the column. In our case, it will be below the column of interest.

Step 3: Start the SUM Formula

Type “=SUM(” in the selected cell to initiate the formula.

Step 4: Select the Range

Define the range of cells you want to add up by typing the range in the formula. For example, if you want to sum values from B2 to B7, type “=SUM(B2:B7)”. You can also click and drag your mouse over the desired range to select it automatically.

Step 5: Close the Formula and Get the Results

Complete the formula by adding a closing parenthesis “)” and press Enter. Google Sheets will automatically calculate and display the sum of the specified range in the chosen cell.


Adding up a column in Google Sheets is a simple and straightforward process that can be accomplished in just a few steps. By following the steps outlined in this guide, users can efficiently and accurately calculate column totals in Google Sheets to streamline their data analysis and reporting tasks.