Ask Your Question

Create cumulative sum/ running total in column

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

jolive gravatar image

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 flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-01-31 01:54:33 +0200

updated 2018-08-14 01:11:30 +0200

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.

edit flag offensive delete link more



Good answer @Gilberto Schiavinatto, but the spaces inside the formula cause an error 501.

Please edit it without spaces as =SUM(A$1:A1)

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

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

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

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

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

Ok @quazgar, done.

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

answered 2018-01-31 18:04:25 +0200

jolive gravatar image

What is the "$" in the formula for?

edit flag offensive delete link more


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.

librebel gravatar imagelibrebel ( 2018-01-31 18:14:41 +0200 )edit

$1 = sets the value 1, does not change when replicating in the column below.

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

answered 2018-08-26 08:54:49 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 4,393 times

Last updated: Aug 26 '18