Other Content

Table Of Contents
308 Lists&Spreadsheet Application
Inserting a Cell Range into a Formula
The Select Range feature lets you insert a cell range (such as a1:b3) into a
formula by selecting the range instead of typing cell addresses into an
argument.
Suppose you want to calculate the mean of a range of cells.
1. Select the cell that will contain the result.
2. From the Data menu, click ListMath>Mean.
An editable formula appears in the cell.
3. Click Actions>Select>Select Formula Range.
4. Drag a selection rectangle around the range of values for which you want
to calculate the mean.
Handheld: Move to the first cell in the range, hold g, and press the
arrow keys.
The formula is updated as you select the cells.