# Quick Calculations In Mac Numbers

You can get the sum, average and perform other calculations on selected cells without needing to create a formula in another cell. The Quick Calculations appear at the bottom of the Numbers window whenever you have more than one cell selected. They also can be dragged-and-dropped to create permanent formulas and will obey filters.

### Comments: 8 Responses to “Quick Calculations In Mac Numbers”

Carl Sechrest
2 years ago

Is it possible to do Quick Calculations using an iPad and Numbers?

2 years ago

Carl: This doesn't work the same way in Numbers for iPad, no.

Jeff
2 years ago

Using 11.1 numbers; Watched your video on linking cells in other tables. BUT, it won't link a cell connected / using a formula with other cells in a table to another tables.
Example: I create a basic food costing formula. =price unit/portion to give the sum of cost per unit in a recipes. Fine, works. BUT when you pull that cell with the cost per unit in a recipe into another table it RED triangles. Everything from "string issue" to missing a number. Why do this? Because when I update the price..

2 years ago

Jeff: Not sure what you are experiencing there. Check your formula carefully. Or maybe you are looking for something different. See https://macmost.com/create-powerful-numbers-spreadsheets-with-the-indirect-function.html

Leif
2 years ago

Problem: a large number of lines with data in columns (needed to be scrolled) require quick calculations (to be saved in new data sheet) for different columns (but same lines).
Question: how to move the highlight from one column to the next without having to scroll/re-highlight the same lines?
Hope you understand.

2 years ago

Leif: Sorry, no, I can't figure out what you mean with that description. Tray asking at https://macmost.com/ask and describe it using cell references like B4 or F99.

Zoran
2 years ago

Hey Gary,
how do I change the value in the field based on another field?
Example:
If the value in field A is 3500 set the field B to 90

2 years ago

Zoran: Sounds like you are looking for the IF function. https://macmost.com/learn-how-to-use-the-if-function-in-numbers.html