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

    Carl Sechrest
    4 months ago

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

    4 months ago

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

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

    3 months 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
    4 weeks 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.

    4 weeks 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.

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)