Ask Your Question

formula for running total in calc

asked 2017-07-01 02:57:57 +0100

joeth gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-01 03:06:29 +0100

robleyd gravatar image

Assuming 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.

edit flag offensive delete link more


Lovely - thanks for the quick response.

joeth gravatar imagejoeth ( 2017-07-01 03:29:05 +0100 )edit

answered 2018-08-26 08:55:12 +0100

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: 2017-07-01 02:57:57 +0100

Seen: 691 times

Last updated: Aug 26 '18