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

  1. Go to the Numbers app on your Mac.

  2. In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.

    Calculations for the selected cells—for example, the sum, average, minimum, maximum—appear at the bottom of the window.

  3. 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.

  1. Go to the Numbers app on your Mac.

  2. In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.

  3. Click the Gear icon, 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 in a calculator.

  1. Go to the Numbers app on your Mac.

  2. In a spreadsheet, click a blank cell where you want to add your formula, then type the equal sign (=) to open the Formula Editor.

  3. 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 parentheses; 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
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.