Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 26 Aug 2018 08:55:12 +0200formula for running total in calchttps://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/ Very basic question I know, but I couldn't seem to find the answer in Help.
I'm keeping a simple tally of expenditures down one column in Calc, and want to have the running total appear automatically in the next column. How do I do that please?Sat, 01 Jul 2017 02:57:57 +0200https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/Answer by arindam for <p>Very basic question I know, but I couldn't seem to find the answer in Help.
I'm keeping a simple tally of expenditures down one column in Calc, and want to have the running total appear automatically in the next column. How do I do that please?</p>
https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?answer=163886#post-id-163886Here's a example and tutorial on running total column in Calc:
[https://libreofficehelp.com/create-running-total-column-libreoffice-calc/](https://libreofficehelp.com/create-running-total-column-libreoffice-calc/)Sun, 26 Aug 2018 08:55:12 +0200https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?answer=163886#post-id-163886Answer by robleyd for <p>Very basic question I know, but I couldn't seem to find the answer in Help.
I'm keeping a simple tally of expenditures down one column in Calc, and want to have the running total appear automatically in the next column. How do I do that please?</p>
https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?answer=107061#post-id-107061Assuming expenditures in A:
B1: =A1
B2: =A2+B1
Drag B2 down as far as needed.
*If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.*Sat, 01 Jul 2017 03:06:29 +0200https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?answer=107061#post-id-107061Comment by joeth for <p>Assuming expenditures in A:</p>
<pre><code>B1: =A1
B2: =A2+B1
</code></pre>
<p>Drag B2 down as far as needed.</p>
<p><em>If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.</em></p>
https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?comment=107063#post-id-107063Lovely - thanks for the quick response.Sat, 01 Jul 2017 03:29:05 +0200https://ask.libreoffice.org/en/question/107044/formula-for-running-total-in-calc/?comment=107063#post-id-107063