Sum with variable rows [closed]

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

JM
13 ●1 ●1 ●3

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

Comments

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

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

add a comment

1

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

m.a.riosv

25929 ●9 ●53 ●140

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

edit flag offensive delete link

Comments

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 ( 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 ( 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 ( 2013-12-27 00:29:21 +0200 )edit

add a comment

0

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

JM
13 ●1 ●1 ●3

That worked! Thanks a lot!

edit flag offensive delete link

add a comment

Sum with variable rows [closed]

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

Sum with variable rows [closed] edit

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

Sum with variable rows [closed]

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