Spreadsheet help please

[PeteXXX]

I'm sure it won't take long for some helpful person here to do this really easy task that is beyond me.
All I want it to do, when I put a £sterling number in column B, is to do a running total in column D

And it needs to work in, and be savable to, .ODT format for LibreOffice, but I can't upload a file in .ODT format here.

 

[Spinney]

In D2, put =B2
In D3 put =D2+B3
Then just fill down column D starting at D3...
(assuming LibraOffice works like Excel - filling down will give you
=D3+B4
=D4+B5 etc)

 

[winjim]

Any good?

 

[Wafer]

In D2 type =B2
Then in D3 type =D2+B3
Then copy D3 down as far as you want it to go, or when you add new rows, copy the formula down then.

Here's an ods file https://www.dropbox.com/s/y1p7mo93v2cobax/running total.ods?dl=0
Just need to copy D3 down the column as you need it

 

[Spinney]

I wonder how many different, but workable, solutions there will be!

 

[winjim]

D2=SUM($B$2:$B2)

Copy down.

The advantage is that it uses the primary data and doesn't rely on using the previous running total, which is already the result of a function. Allows you to fill col B in any order and not worry about blank cells. :-)

 

[PeteXXX]

In D2, put =B2
In D3 put =D2+B3
Then just fill down column D starting at D3...
(assuming LibraOffice works like Excel - filling down will give you
=D3+B4
=D4+B5 etc)

That looks complicated! (but I'll give it a go) thanks...

 

[PeteXXX]

Any good?

I tried that, but when it opens and runs in LibreOffice, the next number I put in column B isn't in '£' format and doesn't then add to or display the total in column D, but thanks.

 

[winjim]

I tried that, but when it opens and runs in LibreOffice, the next number I put in column B isn't in '£' format and doesn't then add to or display the total in column D, but thanks.

You'll need to copy the function down the column. I haven't touched the number formatting, it should be as you left it.

 

[deptfordmarmoset]

I tried that, but when it opens and runs in LibreOffice, the next number I put in column B isn't in '£' format and doesn't then add to or display the total in column D, but thanks.

Highlight the column from the B box at the top and right click to format it as currency.

 

[PeteXXX]

In D2 type =B2
Then in D3 type =D2+B3
Then copy D3 down as far as you want it to go, or when you add new rows, copy the formula down then.

Here's an ods file https://www.dropbox.com/s/y1p7mo93v2cobax/running total.ods?dl=0
Just need to copy D3 down the column as you need it

That's kind of right, but the total doesn't carry on down. Probably me though not understanding the copy D3 thingy...
Thanks

 

[Wafer]

Try the link again, I've updated it, this time with the D column already copied down a way

 

[PeteXXX]

Highlight the column from the B box at the top and right click to format it as currency.

When I created the spreadsheet, I did that. Maybe the format got lost in saving it as .xlsx

 

[winjim]

Better still:

D2=if(isblank(B2),"",SUM($B$2:$B2))

Only fills in column D if there's a value in column B. I've copied it down to row 20.

 

[Wafer]

https://help.libreoffice.org/Calc/Copying_Formulas might help you too