Calc SUM function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the SUM function.

Description

Returns the sum of the arguments.

Syntax

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

• number1 - Required. The first number or variable for which you want the sum.
• number2, ... - Optional. Additional numbers or variables for which you want the sum, up to a maximum of 255.

Remarks

• Arguments can only be numbers or variables that represent numbers.
• If argument contains text, logical values, or empty values, those values are ignored; however, the value zero is included.
• Arguments that are error values or text that cannot be translated into numbers cause errors.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc ABS function
• Calc AVERAGE function
• Calc CEILING function
• Calc COS function
• Calc COUNT function