Numbers - The Elements of Formulas

background image

Using Formulas in Tables

background image

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