Google Sheets SUM Function
SUM Function
The SUM function is a premade function in Google Sheets, which adds up numbers in a range.
It is typed =SUM
and gets a list of cells:
=SUM(value1, [value2, ...])
You can select cells one by one, but also ranges, or even multiple ranges.
Note: The =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 SUM function, step by step:
- Select the cell
B12
- Type
=SUM
- Click the SUM command
- Specify the range
B2:B10
for 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 3092
.
Let's change one of the values in the range, to see what happens. Type 350
into cell B7
:
Rattata total stats was changed from 253
to 350
.
The SUM function updated the total sum from 3092
to 3189
.
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 B7
:
The SUM is updated to 2489
. Adding a negative number subtracts that value from the range.