![]() ![]() Now, in this case my Mac didn’t get smart and try to auto-sum anything, but if yours does, Numbers might just populate that cell with the references around it: 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |