Ask Your Question
1

Create cumulative sum/ running total in column

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

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
1

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

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

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

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)

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

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

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2018-02-01 01:07:35 +0100 )edit

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

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

Ok @quazgar, done.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2018-08-14 01:12:25 +0100 )edit
0

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

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

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

edit flag offensive delete link more
0

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

jolive gravatar image

What is the "$" in the formula for?

edit flag offensive delete link 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.

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

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

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2018-02-01 01:11:24 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,459 times

Last updated: Aug 26 '18