SUM

Calculates the sum of the received numbers and lists of numbers by adding every number together

Usage

SUM(number_or_list...)

Parameters

number_or_list

(Required) A number or a list of numbers to include in the sum

...

There can be many number_or_list. They are added together.

Examples

Example With these variables Result

SUM(numbers)

numbers is [10, 20, 30]

60

SUM(5, 8, 12)

(None)

25

SUM(a_number, numbers)

a_number is 100
numbers is [10, 20, 30]

160

Reminders

A text containing digits is not handled as a number. To have an actual number:

  • use the @NUMBER_QUESTION to set the variable
  • write a numeric value directly in the code without quotes, ex: age >= 18
  • use a function which converts to a number: NUMBER(text_containing_numbers)
  • use a function which returns a number: FIND("world", "hello everybody")

See also