0

If I have columns that sum at the bottom, how can I have the sum function automatically include a newly inserted row.

    a
  +---+
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
  +---+
  |=sum(a1:a4)|

Then when I add row 5 the sum function should be

=sum(a1:a5)

1 Answer 1

0

This functionality is embedded and its default behaviour. Of course if adding a row will be done using this option:

enter image description here

5
  • The function will only be updated when a row was inserted into the middle between a1 and a4, but it does not work when I add a row after a4. Dec 29, 2012 at 0:19
  • Number '09 does, I've checked it twice.
    – maseth
    Dec 29, 2012 at 11:21
  • Was the answer useful?
    – maseth
    Jan 6, 2013 at 19:08
  • It does work. I have to add the row below the last row in the group. I was attempted to add a new row above the sum function. Jan 7, 2013 at 7:36
  • I edited your answer to be more correct. Thank you. Jan 7, 2013 at 7:39

You must log in to answer this question.

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