Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 27 Dec 2013 14:35:57 +0100Sum with variable rowshttps://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/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, JMThu, 26 Dec 2013 21:50:01 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/Comment by sargdavid for <p>Hi there, i need you help.
I have for example:</p>
<p>Row 1: 8
Row 2: 90
Row 3: 98 | Total</p>
<p>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.</p>
<p>Thanks for the time,</p>
<p>Best Regards, JM</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27548#post-id-27548Can you please describe the exact procedure: how do you insert the row (see my comment to the answer below)?Thu, 26 Dec 2013 23:53:40 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27548#post-id-27548Answer by JM for <p>Hi there, i need you help.
I have for example:</p>
<p>Row 1: 8
Row 2: 90
Row 3: 98 | Total</p>
<p>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.</p>
<p>Thanks for the time,</p>
<p>Best Regards, JM</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?answer=27573#post-id-27573That worked! Thanks a lot!
Fri, 27 Dec 2013 14:35:57 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?answer=27573#post-id-27573Answer by m.a.riosv for <p>Hi there, i need you help.
I have for example:</p>
<p>Row 1: 8
Row 2: 90
Row 3: 98 | Total</p>
<p>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.</p>
<p>Thanks for the time,</p>
<p>Best Regards, JM</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?answer=27545#post-id-27545Try enable Menu/Tools/Options/LIbreOffice calc/General/Expand references when new columns/rows are inserted.Thu, 26 Dec 2013 23:18:37 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?answer=27545#post-id-27545Comment by sargdavid for <p>Try enable Menu/Tools/Options/LIbreOffice calc/General/Expand references when new columns/rows are inserted.</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27552#post-id-27552oh, 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!Fri, 27 Dec 2013 00:29:21 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27552#post-id-27552Comment by m.a.riosv for <p>Try enable Menu/Tools/Options/LIbreOffice calc/General/Expand references when new columns/rows are inserted.</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27550#post-id-27550This 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.Fri, 27 Dec 2013 00:13:27 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27550#post-id-27550Comment by sargdavid for <p>Try enable Menu/Tools/Options/LIbreOffice calc/General/Expand references when new columns/rows are inserted.</p>
https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27547#post-id-27547Shouldn'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.Thu, 26 Dec 2013 23:51:45 +0100https://ask.libreoffice.org/en/question/27543/sum-with-variable-rows/?comment=27547#post-id-27547