User Guide

=SUM(A2:A10): A formula that uses the function SUM to add the values in a range
of cells (nine cells in the rst column).
A2:A10: A cell reference that refers to the values in cells A2 through A10.
To learn how to Go to
Instantly display the sum, average, minimum
value, maximum value, and count of values in
selected cells and optionally save the formula
used to derive these values
“Performing Instant Calculations” on page 116
Quickly add a formula that displays the sum,
average, minimum value, maximum value, count,
or product of values in selected cells
“Using Predened Quick Formulas” on page 117
Use tools and techniques to create and modify
your formulas
“Adding and Editing Formulas Using the Formula
Editor” on page 119
“Adding and Editing Formulas Using the Formula
Bar” on page 12 0
“Adding Functions to Formulas” on page 121
“Removing Formulas” on page 12 3
Use the hundreds of iWork functions and review
examples illustrating ways to apply the functions
in nancial, engineering, statistical, and other
contexts
Help > “iWork Formulas and Functions Help”
Help > “iWork Formulas and Functions User
Guide”
Add cell references of dierent kinds to a formula “Referring to Cells in Formulas” on page 12 3
“Using the Keyboard and Mouse to Create and
Edit Formulas” on page 12 5
“Distinguishing Absolute and Relative Cell
References” on page 126
Use operators in formulas “The Arithmetic Operators” on page 12 7
“The Comparison Operators” on page 12 7
Copy or move formulas or the value they
compute among table cells
“Copying or Moving Formulas and Their
Computed Values” on page 12 8
Find formulas and elements in them “Viewing All Formulas in a Spreadsheet” on
page 129
“Finding and Replacing Formula Elements” on
page 13 0
Performing Instant Calculations
In the lower left of the Numbers window, you can view the results of common
calculations using values in two or more selected table cells.
To perform instant calculations:
1 Select two or more cells in a table. They don’t have to be adjacent.
11 6 Chapter 6 Using Formulas in Tables