We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

formula for running total in calc

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

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 +0200

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 +0200 )edit

answered 2018-08-26 08:55:12 +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: 2017-07-01 02:57:57 +0200

Seen: 2,000 times

Last updated: Aug 26 '18