Sum

The Sum function adds the numerical values in a column or group.

Syntax

Sum(column)

Function arguments:

• column (required) - The column of numbers to add together. Any Null or empty values are skipped.

Example

Sum([Price]) - Sum([Cost])

• Finds the total Profit by finding the sum of the Prices and subtracting the sum of the Costs.