Apple numbers User Manual
92
Chapter 5
Using Formulas and Functions in Tables
Here are ways to add a cell reference at the insertion point in the text field:
m
To create a reference to a specific cell by using your mouse, click the cell.
You can also type a reference to a specific cell. Use the column letter followed by the
row number (A4) in the reference tabs or use the column name followed by the row
name (2006 Class Enrollment).
row number (A4) in the reference tabs or use the column name followed by the row
name (2006 Class Enrollment).
If the other table is on a different sheet, click the sheet in the Sheets pane before
selecting the cell.
selecting the cell.
To refer to a cell in a different table, use the table name followed by two colons (::) and
then the cell identifier (Table 2::B5). To refer to a cell in a table on another sheet, use
the sheet name first (Sheet 2::Table 2::2006 Class Enrollment) if the table name isn’t
unique in the spreadsheet.
then the cell identifier (Table 2::B5). To refer to a cell in a table on another sheet, use
the sheet name first (Sheet 2::Table 2::2006 Class Enrollment) if the table name isn’t
unique in the spreadsheet.
m
To add a reference to a list of individual cells, click each cell. If the references are
arguments in a function, Numbers automatically inserts a comma (,) between the
references, which you can replace with a different character if needed. For example, if
you’re in a location where the decimal separator is a comma, you can separate multiple
cell references using a semicolon instead of a comma.
arguments in a function, Numbers automatically inserts a comma (,) between the
references, which you can replace with a different character if needed. For example, if
you’re in a location where the decimal separator is a comma, you can separate multiple
cell references using a semicolon instead of a comma.
m
To add a reference to a range of adjacent cells, drag over the cells you want to add.
You can also type or click the first cell, type a colon, and then type or click the last cell.
For example B2:B5 refers to four cells in the second column. B2:C3 refers to two cells in
the second column and two cells in the third column.
For example B2:B5 refers to four cells in the second column. B2:C3 refers to two cells in
the second column and two cells in the third column.
m
To refer to all the cells in a column, click the column’s reference tab or click its header
cell if there is one.
cell if there is one.
You can type the reference by using the column letter (C or C:C) or the column name if
there’s a header cell. For example, SUM(B) or SUM(B:B) adds all the values in the cells of
the second column.
there’s a header cell. For example, SUM(B) or SUM(B:B) adds all the values in the cells of
the second column.
m
To refer to all the cells in a row, click the row’s reference tab or click its header cell if
there is one.
there is one.
You can type the reference by using the row number (1:1) or the row name if there’s a
header cell. For example, SUM(1:1) adds all the values in the cells of the first row.
header cell. For example, SUM(1:1) adds all the values in the cells of the first row.
Copying or Moving Formulas with Cell References
You can copy or move a formula that contains cell references without invalidating the
references.
references.
Here are techniques for relocating formulas:
m
To move a formula to a different cell, move the formula’s cell by dragging it to another
cell.
cell.