![]() ![]() If that’s the case for you, just click the cell again and delete out the offending data, leaving your cursor in the middle of the blank formula, like so: 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. |