Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to add cells in Google Sheets.
How To Add Cells In Google Sheets
Adding numbers is one of the most basic operations in Google Sheets, and there are a few different ways to do it.
The SUM tool allows you to select a range of cells to add, and the AutoSum tool automatically detects the range of cells to add based on the adjacent cells.
When working with data in Google Sheets, you may need to find the total of a range of cells. This can be helpful if you want to see the sum of a column of data, for example.
In this guide, we will show you how to add a range of cells in Google Sheets using the SUM function and the AutoSum tool
How To Find the Sum of Cells In Google Sheets
Here’s how to find the sum of cells in Google Sheets.
The first example in this guide will show you how to use the SUM function to find the total of all values in a given range.
First, select an empty cell to place the SUM function in.
Next, type the string “=SUM(“ to start the SUM formula.
The SUM function can include any number of arguments. For example, =SUM(1,1,1) will return a value of 3. However, the SUM function can also accept a cell range as input.
In our current example, we’ll use the cell reference A2:A14 as an argument to refer to the range of values we want to add in column A.
Hit the Enter key to evaluate the SUM function. In our example, we were able to determine that the sum of all the values in column A is 344.
While the previous method is simple enough, there is an even quicker method of finding the sum of a range.
First, select the range you want to add.
Next, click on the Equation icon on the far-right side of the toolbar.
Select the SUM option from the drop-down list.
Google Sheets will now automatically add a formula that finds the sum of all values in the selected range.
The AutoSum feature will use the cell directly below the last element in the given selection.
To return the sum, hit the Enter key to evaluate the formula.
This guide should be everything you need to add cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula