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.

Thats cool, and heres how youll do it Step one is to start creating the formula thatll add up (or average, or what have you) the cells in question.

Fill In Numbers In Excel Plus Button With

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.

As you can see above, you can then pick which formula you want; Im selecting Sum, whichll put that equation right into my chosen cell.

Fill In Numbers In Excel Mac Didnt Get

Now, in this case my Mac didnt get smart and try to auto-sum anything, but if yours does, Numbers might just populate that cell with the references around it: If thats 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: Once youre ready to fill in the correct information, make sure youve got the formula up and waiting with your cursor in it if necessary, then select your other sheets one at a time and click on the cells from those sheets youd like to use.

If youve done it correctly, the formula will stay active while youre clicking around, and the cells youre adding will appear in the box as they are above for me.

When youre done, click the green checkmark next to the formula box or press Return, and when you go back to the original sheet, youll see your finished calculation.

I mean, thats gonna take you longer than clicking around will, but if you prefer doing things that way, go you Now, since Im doing income and expenses here, I should probably go in and edit that formula so its not adding those numbers, its subtracting expenses from income.

Adding my expenses to my income iswell, that wouldnt give me a great idea of where my budget is.

Anyway, Ill do that by just double-clicking the formula cell and dropping that minus sign in instead.

Two things that are important: No, thats not actually how much money I make in a month.

Share this: Facebook Twitter LinkedIn Reddit More Print Tumblr Tags: Documents, iWork, macOS, Numbers, tips Related Articles The Mac Observers Videos.

Sheet 2 on wards using the data from one column only ie sheet 2 is the data from column 2, sheet 3 from column 3 etc.

Do I have to manually enter the formulas for Numbers to pull the cell values or is there a way of cutting pasting that will auto-populate the correct column to the correct sheet ie when pasting formulas it can Read more.

The function sums the values of the cell C22 in Alpha, Omega and all the sheets between them.

Buy from our preferred vendors, including The Apple Store and MacMall.

Featured Editorials The Apple Watch Series 3 Competes With Fitbit Sense.

Come join the fun report this ad Sponsors AAPL Stock Price 115.54 0.19 (0.16) Quotes are delayed.

How To Fill In Numbers In Excel For Mac