Numbers

Table of Contents

Quickly calculate a sum, average and more in Numbers on Mac

You can make calculations in your table without having to insert a formula or function.

Drag to reorder functions, drag a calculation to a table cell to add it, or click the change functions menu to change which functions are shown.

Make quick calculations for a range of cells

Select the column or row (or the range of cells), the calculations of which you want to see.
Calculations for the selected cells—for example, the sum, average, minimum, maximum—appear at the bottom of the window.
To add a formula with the calculation to your table, drag the calculation to a table cell.

Change the instant calculation options

You can add or remove the functions you see when you select a range of cells.

Select the column or row (or the range of cells), the calculations of which you want to see.
Click , then choose the functions you want to add or remove.

Use the Formula Editor like a calculator

You can enter number values in formulas to make calculations, just as you would on a calculator.

Click a blank cell where you want to add your formula, then type the equal sign (=) to open the Formula Editor.
Type the equation you want to calculate, using values and arithmetic operators (for example, +,-,* and /).
For example, if you type the equal sign (=), then type “1+1” in the Formula Editor, the cell returns the result of 2. You can also use brackets; if you type 4+6*(3-1), the cell returns the result of 16.

See alsoCalculate values using data in table cells in Numbers on Mac

Helpful?