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?

  • 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 '14 at 17:31
  • How do you add and remove rows? – mmmmmm Jan 2 '14 at 18:03
  • Numbers on OS X. Actually, Numbers inside of Pages. I simply presumed that this is the same "control". – Krumelur Jan 2 '14 at 19:22

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:


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

You must log in to answer this question.

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