I have two columns of numbers for a budget. B1 through B19 are the data I want B20 to show the total
Hello,
Your question is conflicting. Main question says running total
and detail says total
. Also detail says two columns
but you specify only column B
.
If you simply want a total of B1 through B19 see
https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3163596
OK, I"ve attached a file. but basically:
Col C holds the running total
the 2nd cell (c2)holds the sum of cells 1 and 2 (b1+b2)
the 3rd cell hold C2 plus B3 (c2+b3)
4th cell same (c3+b4)
and so on.
After you set up the first 2 cells, you can copy the formula from the 3rd cell down to the rest.
running-total.ods