Ask Your Question

# Create cumulative sum/ running total in column

How do I create a simple function that will sum a cumulative total in a column? That is every descending field will sum the total from the field to the left to the total in the field above.

edit retag close merge delete

## 3 Answers

Sort by » oldest newest most voted

Considering the values being in Column A and the accumulated in B, the formula in B will be = SUM(a$1:a1), and replicate to the cells below. more ## Comments 1 Good answer @Gilberto Schiavinatto, but the spaces inside the formula cause an error 501. Please edit it without spaces as =SUM(A$1:A1)

( 2018-01-31 06:20:41 +0200 )edit

Yes, I did not notice the collage. Google translator that places the spaces.

( 2018-02-01 01:07:35 +0200 )edit

So please edit the answer so that others don't make the same mistake :-)

( 2018-08-13 19:39:25 +0200 )edit

Ok @quazgar, done.

( 2018-08-14 01:12:25 +0200 )edit

What is the "$" in the formula for? more ## Comments Hello @jolive, this is not an answer but a new question. If you want to comment on the given answer, then click on the button "add a comment". If the given answer solves your question, then please mark the answer as correct by clicking on the Checkmark icon on the left. ( 2018-01-31 18:14:41 +0200 )edit $1 = sets the value 1, does not change when replicating in the column below.

( 2018-02-01 01:11:24 +0200 )edit

Here's a example and tutorial on running total column in Calc:

https://libreofficehelp.com/create-running-total-column-libreoffice-calc/

more

## Stats

Asked: 2018-01-31 01:25:22 +0200

Seen: 4,393 times

Last updated: Aug 26 '18