Last Updated on November 1, 2023 by Jake Sheridan
Don’t be fooled by the title of this article. Adding numbers in Google Sheets isn’t just inputting numerical values. It refers to the function of adding numbers — or finding the sum — mathematically through Google Sheets. This tool is incredibly useful for those who need to make quick calculations, record credit/debit transactions made to personal accounts, and for those keeping track of increasing funds or headcounts.
You can find the sum of a list of numbers either through the Explore button or by using a formula. Let’s take a closer look at both of those options.
This is the quickest way to find the sum of the numbers you’re adding.
- First, create your Google spreadsheet.
- Input the list of numerical values that need calculation. Fortunately, numbers do not all have to be in the same column for you to make use of this feature. This way, if your sum is based on numbers in different categories, you do not have to move them to a brand new column specifically for calculation.
- Next, select the numbers you want to add by highlighting specific cells.
- If, as mentioned before, your numbers are in different columns, hold down the Ctrl key for PC or the Command key on a Mac and click on the cells you want.
- On the bottom right hand corner of your spreadsheet screen, you will see a drop down tab and a bubble with a star icon inside of it. This is the “Explore” icon.
- The drop down tab will appear when a group of numbers are highlighted. It defaults to reveal the sum of selected numbers.
- You may also click on the Explore icon to reveal other information about the group of highlighted numbers.
Using a Formula
Using a formula to find the sum of a group of numbers is not only a good way to start building more sophisticated function and conditional formatting knowledge, but also a way to keep track of totals that increase over time. It is also useful if you have individual charts calculating different things on the same spreadsheet.
Syntax is important when it comes to this formula. For example, the key words SUM and ADD mean two different things.
SUM will calculate the number of a series of selected cells as per addition rules.
The formula is: =SUM(value 1, value 2…)
- Choose a blank cell where you would like to display the sum of the numbers you are adding.
- In the formula bar located above the column headers, type in =SUM()
- Clicking first within the brackets, make your selection of numbers by clicking and dragging over the desired range.
- To include numbers that do not appear consecutively, you can add the value by inserting a comma into the formula. After including the comma, select the next value. Do this until all numbers have been chosen.
- Press “Enter” on the keyboard and the sum will appear in the once blank cell.
ADD will calculate the value of two cells as per addition rules.
The formula is: =ADD(value 1, value 2)
- To add two numbers using the ADD formula, choose a blank cell in which you would like to display the total.
- In the formula bar, type =ADD()
- Clicking within the brackets, select your first number.
- Insert a comma into the formula and then choose your second value.
- Press “Enter” on the keyboard and the addition results will appear in the once blank cell.
Computerized calculations will never make up for the thought and logic that goes into mathematical equations. Still, the calculator-like finesse of Google Sheets’ add feature is sure to make quick work of big jobs.
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
- Add Cells
- 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