Sum

Sum is a mathematical function that returns the summation of a group of numeric values, rows, columns, or cells.

Syntax:

Sum(arguments)

where arguments is one or more of the following values:

Argument	Description
numeric	A numeric value. For example, Sum(10,20,30) returns the value 60. Numeric values can include decimals and negative values. See Numeric Arguments.
row, column, or cell referenc	A pointer to a row, column, or cell within a grid.
function	An embedded function. See Mathematical Functions.

Examples:

Return the value 30:

sum(10,20)

Return the sum of three rows:

sum([1], [6], [8])

Calculate the sum of three aggregate columns:

sum([E], [G], [I])

Calculate the sum of two columns that are located on different grids:

sum(grid1.col[E],grid2.colmn[E])