How do I just add a column of numbers in Numbers
I just want to use Numbers to keep track of household expenses. For the life of me I cannot figure out how to simply add a column of numbers to get a total. So simple, yet so far away!
Apple Event: May 7th at 7 am PT
I just want to use Numbers to keep track of household expenses. For the life of me I cannot figure out how to simply add a column of numbers to get a total. So simple, yet so far away!
You can do something like this:
Choose Sum:
Giving you this:
The resulting formula in B6 is:
=SUM(B)
You could also type that formula directly into the cell rather than choosing from the Toolbar.
But if you're tracking expenses you don't need to reinvent the wheel. Highly recommend you take a look at the excellent 'Personal Budget' template at File > New in your menu. Post any questions you have about how to use it and adapt it to your needs.
Also have at look at Help > Numbers Help and Help > Formulas and Functions Help.
SG
You can do something like this:
Choose Sum:
Giving you this:
The resulting formula in B6 is:
=SUM(B)
You could also type that formula directly into the cell rather than choosing from the Toolbar.
But if you're tracking expenses you don't need to reinvent the wheel. Highly recommend you take a look at the excellent 'Personal Budget' template at File > New in your menu. Post any questions you have about how to use it and adapt it to your needs.
Also have at look at Help > Numbers Help and Help > Formulas and Functions Help.
SG
Hi Christine,
SG's suggestion to insert a Footer Row shows the charm of Numbers.
It took me a long time to understand that Numbers (unlike Excel) is based around several small tables, each with a purpose.
A formula in a Footer Row (or a Header Row) is isolated from all the"Body" (non Header and non Footer) rows in that table. Therefore there is no "self reference" error. A formula can refer to a whole column in a table and we don't need to specify a range of cells.
The formula automatically "expands" if we include extra body rows.
And the formula automatically "shrinks" if we delete body rows.
Please call back with questions.
Regards,
Ian
In your menu at Help > Numbers Help you will find lots of useful information about using Numbers. Highly recommend having a look.
Here is a relevant screenshot from there.
SG
Why isn't this on any of the training information. It is so simple, unless you don't know it.
How do I just add a column of numbers in Numbers