Formulas and Functions

=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 in Numbers
“Performing Instant Calculations in
Numbers” (page 17 )
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” (page 18)
Use tools and techniques to create and modify
your formulas in Numbers
“Adding and Editing Formulas Using the Formula
Editor” (page 19 )
“Adding and Editing Formulas Using the Formula
Bar” (page 20)
“Adding Functions to Formulas” (page 21)
“Removing Formulas” (page 24)
Use tools and techniques to create and modify
your formulas in Pages and Keynote
“Adding and Editing Formulas Using the Formula
Editor” (page 19 )
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
in Numbers
“Referring to Cells in Formulas” (page 24)
“Using the Keyboard and Mouse to Create and
Edit Formulas” (page 26)
“Distinguishing Absolute and Relative Cell
References” (page 27)
Use operators in formulas “The Arithmetic Operators” (page 28)
“The Comparison Operators” (page 29)
“The String Operator and the Wildcards” (page 30)
Copy or move formulas or the value they
compute among table cells
“Copying or Moving Formulas and Their
Computed Values” (page 30)
Find formulas and formula elements in Numbers “Viewing All Formulas in a Spreadsheet” (page 31 )
“Finding and Replacing Formula
Elements” (page 32)
16 Chapter 1 Using Formulas in Tables