Cell Range
A cell range is a range of adjacent cells
defined by its upper left corner and its lower right corner as
reference.
For example, the formula "=Average(A1:B3)", contains the cell range "A1:B3", six cell from column "A", row "1" to column "B" and row "3".
Cell names can define a
cell range as well as a single cell.
Using Cell Ranges
The following screencasts demonstrate how to use cell ranges in cell formulas:
- How to define a name for a cell range.
- How to calculate the sum of a range of cells.
OpenOffice.org™ is a trademark of OpenOffice.org.
