Getting sum of a column of numbers
How can I get the sum total of a column of numbers?
I saw it done by an instructor in the Apple store, but now forget how.
iMac 21.5" 4K, 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.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
How can I get the sum total of a column of numbers?
I saw it done by an instructor in the Apple store, but now forget how.
iMac 21.5" 4K, macOS 10.14
Select the column or Row you want to add and the sum will be displayed at the bottom.
Numbers for Mac: Calculate values using data in table cells in a Numbers spreadsheet
Select the column or Row you want to add and the sum will be displayed at the bottom.
Numbers for Mac: Calculate values using data in table cells in a Numbers spreadsheet
you can, as previously posted, select a column and just look at the quick calculations in the bottom of the Numbers window. If you want the sum in a cell of your table, then drag the quick connect badge from the bottom of the window to the destination cell.
You will not be able to put the sum in the same column unless you open the table formatter and make sure there is at least one footer row.
another way is to select the last row of a column. Again, make sure to set at least one row as a footer row:
Then select the cell in the footer (the last row of the column) and type the formula (assuming you want to sum the values in column B):
=sum(B)
Getting sum of a column of numbers