can I sum a column in numbers without using auto select?

Question

Level 1

25 points

can I sum a column in numbers without using auto select?

I know I can select the first cell in a column then drag the selection down to sum, but when i add a row I need to do the same thing again adding the cell in the new row to the election and sum.

Is there a way to just say I want all the cells in the column summed and put into the totals cell at the bottom of the column(footer)?

Perhaps this is small annoyances, but I add so many rows and want so many columns totaled that it becomes annoying.

Thanks for your help.

Posted on May 1, 2021 6:29 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

30,384 points

May 1, 2021 8:03 AM in response to PurduefanGA

Instead of SUM(B2:B20) you can use =SUM(B). The "B" will refer to all cells in the column other than header and footer cells.

But I'm not clear what you are doing and why when you add a new row it is not being included in your sum automatically. If I have a table with the formula =SUM(B2:B20) in the footer (row 21) and I add a new data row at the bottom, the sum in the footer adjusts to be =SUM(B2:B21).

Reply

Answer 2

SGIII

Level 8

37,550 points

May 1, 2021 8:09 AM in response to PurduefanGA

PurduefanGA wrote:

Is there a way to just say I want all the cells in the column summed and put into the totals cell at the bottom of the column(footer)?

Yes! Numbers makes this easy. Define the bottom row as a Footer Row. One way to do that is this:

Then in the formula refer to the entire column, like this:

=SUM(A)

Now, when you add a new body row (you can do that going to the last row before the Footer Row and hitting <return>) the formula will automatically include the value in the new row.

SG

Reply