How do I total a column in Numbers?
How do I total a column in Numbers?
iMac 27", macOS 10.14
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do I total a column in Numbers?
iMac 27", macOS 10.14
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
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
You can use the formula =sum(A2:A24) just replace the letter with the one that corresponds to your column and the first number is where your column starts and then the last number is obviously where it ends. So in my example its going to add up all the values in column A starting with cell 2 all the way to cell 24.
How do I total a column in Numbers?