Google Sheets SUM Function
The SUM function is a premade function in Google Sheets, which adds up numbers in a range.
It is typed
=SUMand gets a list of cells:
You can select cells one by one, but also ranges, or even multiple ranges.
=SUM function adds up both negative and positive cell values.
Let's see some examples!
Sum Function Example
Calculate the sum of all the Total stats for this list of Pokemon:
The SUMSUM function, step by step:
- Select the cell
- Click the SUM command
- Specify the range
B2:B10for the Total stats
- Hit enter
Now, the function calculates the sum of Total stats for the Pokemon in the list:
Great job! You have successfully calculated the sum of the stats using the
=SUM function. The Pokemon's stats have a total sum of
Let's change one of the values in the range, to see what happens. Type
350 into cell
Rattata total stats was changed from
The SUM function updated the total sum from
It updates the SUM when values inside of the range are changed.
Lets change Rattata's stats to a negative number to see what happens. Type
-350 into cell
The SUM is updated to
2489. Adding a negative number subtracts that value from the range.