Formulas and Functions

Chapter 1 Using Formulas in Tables 25
Cell references have dierent formats, depending on such factors as whether the cell’s
table has headers, whether you want to refer to a single cell or a range of cells, and so
on. Here’s a summary of the formats that you can use for cell references.
To refer to Use this format Example
Any cell in the table containing
the formula
The reference tab letter followed
by the reference tab number for
the cell
C55 refers to the 55
th
row in the
third column.
A cell in a table that has a
header row and a header
column
The column name followed by
the row name
2006 Revenue refers to a cell
whose header row contains
2006 and header column
contains Revenue.
A cell in a table that has
multiple header rows or
columns
The name of the header whose
columns or rows you want to
refer to
If 2006 is a header that spans
two columns (Revenue and
Expenses), 2006 refers to all
the cells in the Revenue and
Expenses columns.
A range of cells A colon (:) between the rst
and last cell in the range, using
reference tab notation to
identify the cells
B2:B5 refers to four cells in the
second column.
All the cells in a row The row name or row-
number:row-number
1:1 refers to all the cells in the
rst row.
All the cells in a column The column letter or name C refers to all the cells in the
third column.
All the cells in a range of rows A colon (:) between the row
number or name of the rst and
last row in the range
2:6 refers to all the cells in ve
rows.
All the cells in a range of
columns
A colon (:) between the column
letter or name of the rst and
last column in the range
B:C refers to all the cells in the
second and third columns.
In Numbers, a cell in another
table on the same sheet
If the cell name is unique in the
spreadsheet then only the cell
name is required; otherwise,
the table name followed by
two colons (::) and then the cell
identier
Table 2::B5 refers to cell B5 in
a table named Table 2. Table
2::2006 Class Enrollment refers to
a cell by name.
In Numbers, a cell in a table on
another sheet
If the cell name is unique in the
spreadsheet then only the cell
name is required; otherwise,
the sheet name followed by
two colons (::), the table name,
two more colons, then the cell
identier
Sheet 2::Table 2::2006 Class
Enrollment refers to a cell in a
table named Table 2 on a sheet
named Sheet 2.