Sum a column in Numbers

Question

Level 1

9 points

Sum a column in Numbers

The explanation as to how to sum a column of numbers in Numbers is as clear as mud to me, even after reading these answers. There used to the the 'f" function key that gave you that option. That is no longer available.

I just want the simple way to add Numbers on my spreadsheet so I can get my taxes done.

Thank-you.

iMac 27″ 5K, macOS 11.6

Posted on Dec 5, 2021 12:06 PM

Reply

Answer 1

Best reply

Badunit

Level 7

26,656 points

Dec 5, 2021 3:37 PM in response to lisa69

Several ways to do it.

Select all the cells to sum
At the bottom of the Numbers window are a few functions, one of which is SUM (you can edit what ones to show)
Drag the sum to where you want it

Select the cells to sum
Use the menu item Insert/Formula/Sum to put the sum in the next row down
Later you can assign a keyboard shortcut to that menu item to save you some time if you do this a lot.

In the cell where you want the sum, type an = to open the formula editor then type SUM(
Select the range of cells to sum then finish it off with a ")" so it looks something like SUM(B2:B15)
Hit Return

Reply

Answer 2

lisa69 Author

Level 1

9 points

Dec 7, 2021 9:03 AM in response to Badunit

Thank-you so much! I hadn't noticed the functions at the bottom of the spreadsheet - I was always searching the menu bar for the function key. As for trying to find Formula/Sum, well, that wasn't my forte. As I only use the sum function once a year for taxes, it didn't get embedded in my brain. Thank you for taking the time to explain this It is simple if you know where to look.

Reply

Sum a column in Numbers

Similar questions