CellSpace/Manual (draft)
by CellWorks
Home
Table of Contents
Glossary
Cells
Ranges
Ranges of
Cells
are used to aggregate values, often with the sum() function.
Ranges can also be passed as arguments to user defined
Functions
.
Ranges
have the form:
<left_cell_coordinate> : <right_cell_coordinate>
For example:
=sum(B26 : J30)
Where B26 : J30 is a two-dimensional range of cells in a
Sheet
.
Ranges are also formed with named
Items
.
For example:
=sum(Oranges : Apples)
Where Oranges and Apples are named
Items
in a 'Products'
Dimension
.