8

I have column which contains prices for my work. The last row of that column should contain the total. Currently I have to adjust the SUM() calculation every time I add or remove a row. Can I somehow magically sum up to the row the SUM() formula is contained in?

3
  • 1
    What exactly is the formula for sum? Do you care about steps for iOS numbers, OS X numbers or all versions?
    – bmike
    Jan 2, 2014 at 17:31
  • How do you add and remove rows?
    – mmmmmm
    Jan 2, 2014 at 18:03
  • Numbers on OS X. Actually, Numbers inside of Pages. I simply presumed that this is the same "control".
    – Krumelur
    Jan 2, 2014 at 19:22

1 Answer 1

9

You can do this using header and footer rows. These automatically adjust the formulas contained within them based on the number of rows above.

  1. Make sure you have the footer row enabled:

  2. In the footer cell, enter =SUM↩︎.

  3. Select the column by clicking the relevant header cell or column reference.

The formula will automatically adjust from now on.


An animation for further explanation:

GIF

1
  • Note that that <Enter> keypress after typing sum is critical. Without it, this weirdly doesn't work.
    – nteissler
    Sep 28, 2020 at 20:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .