To do so, click on the cell where you want your formula to go, and then click the “Insert” button in the toolbar, which looks like a plus button with a box around it.Īs you can see above, you can then pick which formula you want I’m selecting “Sum,” which’ll put that equation right into my chosen cell. Step one is to start creating the formula that’ll add up (or average, or what have you) the cells in question. That’s cool, and here’s how you’ll do it!
In the case of my spreadsheet above, for example, I can take a number from my “Expenses” tab and one from my “Income” tab and use those to populate a summary cell under the “Budget” one. …then you can use a cell in one of those sheets to calculate values in the others.
If you’re working with a Numbers document that has several sheets within it (designated by the tabs near the toolbar)…
