Ask Your Question

Sum with variable rows [closed]

asked 2013-12-26 21:50:01 +0200

JM gravatar image

Hi there, i need you help. I have for example:

Row 1: 8 Row 2: 90 Row 3: 98 | Total

So, in this case i need to do SUM(A1:A2), but if i add a row between the 3 and the 2, this values won't change, so the total, will include only the row 1 + row 2, but need it to include the new row that has been crested between the 2 and the 3, so variable cells.

Thanks for the time,

Best Regards, JM

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-16 18:22:43.444790


Can you please describe the exact procedure: how do you insert the row (see my comment to the answer below)?

sargdavid gravatar imagesargdavid ( 2013-12-26 23:53:40 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-12-26 23:18:37 +0200

m.a.riosv gravatar image

Try enable Menu/Tools/Options/LIbreOffice calc/General/Expand references when new columns/rows are inserted.

edit flag offensive delete link more


Shouldn't matter: I have it unchecked but it still adjust the formula when I'm inserting a row. E.g. I had A1=1 and A2 = 2. A3 = SUM(A1:A2). When I inserted new cell before A2 => shifted the cells down, and entered A2 = 4, the sum in (now) A4 = SUM(A1:A3) = 7, which is correct.

sargdavid gravatar imagesargdavid ( 2013-12-26 23:51:45 +0200 )edit

This option is intended when insertion is just below/right, e.g. if you have = SUM(A1:A2) and insert the row in A3. But when you insert inside a formula range, it is always expanded.

m.a.riosv gravatar imagem.a.riosv ( 2013-12-27 00:13:27 +0200 )edit

oh, I see...just inserted a cell above A3 - the cell that contained the formula, and the formula didn't adjust. Then followed your instructions above and it worked!

sargdavid gravatar imagesargdavid ( 2013-12-27 00:29:21 +0200 )edit

answered 2013-12-27 14:35:57 +0200

JM gravatar image

That worked! Thanks a lot!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-12-26 21:50:01 +0200

Seen: 1,657 times

Last updated: Dec 27 '13