cellsum

Calculates the sum of the referenced cells.

Syntax

cellsum("option", cellref1, cellref2...cellrefn)

Argument

"option"
The "option" argument can be one of two types, "range" or "list".
"range"
Each pair of cell references define a cell range.
"range" is inclusive. For example, cellsum("range", b2, b10) returns the sum of all cells between the cells b2 and b10.
"range" always has an equal number of arguments: 2, 4, 6, and so on.
"list"
The operation is performed on each cell math reference that follows. Every listed cell will be added.
"list" can have any number of arguments.
cellref1
The cell reference parameters must be legal references to TableView cells. Both relative cell references (b2, c26, e45,...) to cells in the same table and absolute cell references (p1w1_b2, p21w4_c26, ...) to cells in tables in different window and/or pages are supported.

Examples

Get the sum over the cell ranges B3 - B8 and C12 - D14:
=cellsum("range", B3,B8,C12,D14)
Get the sum value of the cells B3, B8 and C14:
=cellsum("list", B3,B8,C14)

Comments

Blank cells and text (string type) cells within the selected range of cells will be ignored when doing the calculations.