Sum()

Working with Formulas > Functions Used in Formulas > List Functions > Sum()

SUM( ) calculates the sum of the numbers in the specified list.

Function Format

SUM(number1 [, number2, number3, ...]) 

Return Value

SUM() returns a numeric value 

Examples

SUM(3, 1, 2) = 6 

SUM(3, 1, 4, 2) = 10 

SUM(-3, 1, -4, 2) = -4