Apple Numbers '09 - Manual (Page 119)

Chapter 6 Using Formulas in Tables 119
=SUM(A2:A10): A formula that uses the function SUM to add the values in a range
of cells (nine cells in the first 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 119
Quickly add a formula that displays the sum,
average, minimum value, maximum value, count,
or product of values in selected cells “Using Predefined Quick Formulas” on page 120
Use tools and techniques to create and modify
your formulas “Adding and Editing Formulas Using the Formula
Editor” on page 122
“Adding and Editing Formulas Using the Formula
Bar” on page 123
“Adding Functions to Formulas” on page 124
“Removing Formulas” on page 126
Use the hundreds of iWork functions and review
examples illustrating ways to apply the functions
in financial, engineering, statistical, and other
contexts Help > “iWork Formulas and Functions Help”
Help > “iWork Formulas and Functions User
Guide”
Add cell references of different kinds to a formula “Referring to Cells in Formulas” on page 126
“Using the Keyboard and Mouse to Create and
Edit Formulas” on page 128
“Distinguishing Absolute and Relative Cell
References” on page 129
Use operators in formulas “The Arithmetic Operators” on page 130
“The Comparison Operators” on page 130
Copy or move formulas or the value they
compute among table cells “Copying or Moving Formulas and Their
Computed Values” on page 131
Find formulas and elements in them “Viewing All Formulas in a Spreadsheet” on
page 132
“Finding and Replacing Formula Elements” on
page 132
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.