SUM

Function Type: Math and Trigonometry

Description:

Adds its arguments. As it is in math, SUM is the function used in Excel or Google Sheets to add numbers.

Function Structure:

=SUM(number1, [number2]).

Argument Breakdown:

number1 – The first value to sum.

number2 – The second value to sum.

Example:

Sum of constant number values:

Sum of values in a range:

Sum of values in a column:

Sum of values of non-contiguous cells: