cellmean

Calculates the mean value of the referenced cells.

Syntax

cellmean("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, cellmean("range", b2, b10) returns the mean 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 mean over the cell ranges B3 - B8 and C12 - D14:
=cellmean("range", B3,B8,C12,D14)
Get the mean value of the cells B3, B8 and C14:
=cellmean("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.