Range
A set of
contiguous cells specified
by the endpoints
12.2
Spreadsheets
379
Because functions often operate on a set of contiguous cells, spread
sheets provide a convenient way to specify a
range
of cells. Syntactically, a
range is specified with two dots (periods) between the two cell endpoints.
A range can specify a set of cells along a row, such as C4..E4, or it can
specify a set of cells down a column, such as C4..C8. A range can also
specify a rectangular block of cells, ranging from the top left to the bottom
right. For example, the range C4..E8 includes the cells C4 to C8, D4 to
D8, and E4 to E8.
Several of the formulas shown in Figure 12.3 use the COUNT function,
which computes the number of nonblank cells in the specified range. For
example, the formula in cell G7 divides the value in cell F7 by the count of
cells in the range C7..E7, which is 3.
The formula in cell G7 could have been written as follows:
=SUM(C7..E7)/3
Given the current status of the spreadsheet, this formula would compute
the same result. However, there are two reasons why this formula is not as
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '10
 MARIANAKANT
 cells, Cell G7

Click to edit the document details