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: 4 Responses to “Quick Calculations In Mac Numbers”

    Carl Sechrest
    3 weeks ago

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

    3 weeks ago

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

    Jeff
    2 days 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 days 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

Leave a New Comment Related to "Quick Calculations In Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)