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 equals 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 equals 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
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
സഹായകമായോ?
കാരക്റ്റർ പരിധി: 250
പരമാവധി കാരക്റ്റർ പരിധി 250 ആണ്.
നിങ്ങളുടെ ഫീഡ്ബാക്കിന് നന്ദി.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.