Sum is a mathematical function that returns the summation of a group of numeric values, rows, columns, or cells.
The syntax for the Sum function is:
Sum (arguments)
where arguments is one or more of these arguments:
Argument | Description |
|---|---|
numeric | A numeric value. For example, Sum(10, 20, 30) returns the value 60. Numeric values can include decimals and negative values. |
row, column, or cell reference | A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax is: GridName.GridElement[segment(range)].property |
function | An embedded function. |
Examples:
The following example returns the value 30:
sum(10,20)
The following example returns the sum of three rows:
sum(row[1],row[6],row[8])
The following example calculates the sum of three aggregate columns:
sum(column[E], column[G], column[I])