The SUM function adds all the numbers together.
Formula:
=SUM(number1,[number2],…)
Explanations:
– Number 1 is required, the first number to add.
– Number 2… is optional, the rest of the numbers to add.
Cautions:
– Only numeric values can be added. All cells with logical or text values will be ignored.
Explanations:
– The number is required, the number you want the absolute value.

Example: what is the SUM of 1 and 100?
=sum(1,100), the result returns 101.