CODEWITHSUNDEEP
libreofficelibreoffice-calc
Severus Snape
Severus Snape

Reputation: 192

Running total using two columns

Given a table with data like:

A B
Qty. Running Total
5 5
5 10
5 15

I can create the running total using the formula =SUM($A$2:A2) and then drag down to get the running total after each quantity (here Qty.)

What may I do for calculating running total using two columns which may or may not be consecutive as shown below:

A B C D
Qty. 1 Other Qty. 2 RT
2 blah 2 4
2 phew 2 8
3 xyz 2 13

Upvotes: 0

Views: 731

Answers (1)

JohnSUN
JohnSUN

Reputation: 2539

Place in cell D2 the formula =SUM(A2,C2,D1). Do not pay attention to the fact that the function will refer to a non-numeric cell D1 - the SUM() function will not break, unlike ordinary addition =A2+C2+D1. Now, just stretch the formula down.

Upvotes: 1

Related Questions