You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I total a column in Numbers?

How do I total a column in Numbers?

iMac 27", macOS 10.14

Posted on Nov 25, 2019 12:05 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 25, 2019 6:12 PM

In Numbers totaling a column is simple.



Add a 'Footer Row' at the bottom of your Table (click the row number at the left and choose Convert to Footer Row or Add Footer Row Below. Row 10 is a Footer Row here.


Then click in the cell where you want the sum (A10 in this example) and click the icon in the Tool Bar that looks like a rectangle with a + in it and then choose Sum. That's it!


The formula looks like this:



=SUM(A)


If you want you can type that formula directly in the cell rather than going to the Toolbar.


Note that unlike in Excel in Numbers you typically sum the whole column. That's cleaner and easier than specifying a range of cells like A2:A24.


Unlikely in Excel, in Numbers you can easily work with a Number of smaller tables to simplify your work.


Have a look at the templates at File > New in your menu for good examples of how to do things "the Numbers way."


SG





2 replies
Question marked as Top-ranking reply

Nov 25, 2019 6:12 PM in response to lowellfromboise

In Numbers totaling a column is simple.



Add a 'Footer Row' at the bottom of your Table (click the row number at the left and choose Convert to Footer Row or Add Footer Row Below. Row 10 is a Footer Row here.


Then click in the cell where you want the sum (A10 in this example) and click the icon in the Tool Bar that looks like a rectangle with a + in it and then choose Sum. That's it!


The formula looks like this:



=SUM(A)


If you want you can type that formula directly in the cell rather than going to the Toolbar.


Note that unlike in Excel in Numbers you typically sum the whole column. That's cleaner and easier than specifying a range of cells like A2:A24.


Unlikely in Excel, in Numbers you can easily work with a Number of smaller tables to simplify your work.


Have a look at the templates at File > New in your menu for good examples of how to do things "the Numbers way."


SG





How do I total a column in Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.