Spreadsheet help please

[deptfordmarmoset]

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

Does it work by reformatting it? I may try doing that here on Libre Office. It seems like such a routine spreadsheet procedure that I'd be surprised if it didn't work.

 

[PeteXXX]

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

That's great, but it shows the total amount in column D in every cell downwards.

Cheers for the help

 

[Wafer]

Yeah, options are a bit limited if you're that unfamiliar with using spreadsheets. That's not a knock, just stating what seems to be the case.
The 'copy the formula down as you need it' is pretty much the easiest and most full proof thing to do, hence offering the link saying how to do it, though if videos are more your thing, the 15 seconds or so from this point in this youtube video shows how to do it in libreoffice
View: https://youtu.be/G5qTBjsiTe0?t=99

 

[winjim]

Did you try my second attempt?

That's great, but it shows the total amount in column D in every cell downwards.

Cheers for the help

Did you try my second attempt with the if(isblank) function? It solves that problem.

 

[PeteXXX]

Did you try my second attempt?

Did you try my second attempt with the if(isblank) function? It solves that problem.

This is what I'm getting at the moment. Please assume zero knowledge of spreadsheets!

 

[PeteXXX]

Yeah, options are a bit limited if you're that unfamiliar with using spreadsheets. That's not a knock, just stating what seems to be the case.
The 'copy the formula down as you need it' is pretty much the easiest and most full proof thing to do, hence offering the link saying how to do it, though if videos are more your thing, the 15 seconds or so from this point in this youtube video shows how to do it in libreoffice
View: https://youtu.be/G5qTBjsiTe0?t=99

Working on it, thanks.. (No offence taken BTW)

 

[winjim]

View attachment 111685

This is what I'm getting at the moment. Please assume zero knowledge of spreadsheets!

It should look like this

So it adds a running total in column D only if there is a value in column B.

The formula in D2 is:
=IF(ISBLANK($B2),"",SUM($B$2:$B2))

What this does is check if cell B2 is blank. If this condition is true, it returns the value "" which is a blank cell. If this condition is false ie cell B2 is not blank, it returns the sum of all values in the range B2:B2, which is just one cell. As you copy the formula down, the logical test moves to the next row and the range increases accordingly, so D5 for example checks for a blank in B5 and returns the sum of the range B2:B5. The $ signs stop the next value from incrementing as you copy the formula, so for example $B$2 will always refer to B2, but $B2 would become B5 if you copied it to row 5.

Does that make sense?

 

[threebikesmcginty]

Have you tried slamming the mouse down repeatedly and screaming at the screen "work you f***ing b*stard"?

 

[PeteXXX]

It should look like this
View attachment 111688

So it adds a running total in column D only if there is a value in column B.

The formula in D2 is:
=IF(ISBLANK($B2),"",SUM($B$2:$B2))

What this does is check if cell B2 is blank. If this condition is true, it returns the value "" which is a blank cell. If this condition is false ie cell B2 is not blank, it returns the sum of all values in the range B2:B2, which is just one cell. As you copy the formula down, the logical test moves to the next row and the range increases accordingly, so D5 for example checks for a blank in B5 and returns the sum of the range B2:B5. The $ signs stop the next value from incrementing as you copy the formula, so for example $B$2 will always refer to B2, but $B2 would become B5 if you copied it to row 5.

Does that make sense?

That's the result I want, thanks. It makes sense, yes, but I wouldn't know where to start creating such stuff.

 

[ClichéGuevara]

I've read all the posts in this thread and they simply don't add up.

Sum do.

 

[Spinney]

That's the result I want, thanks. It makes sense, yes, but I wouldn't know where to start creating such stuff.

On CycleChat, obviously!!

 

[PeteXXX]

On CycleChat, obviously!!

CC was my first port of call

 

[mybike]

OK, silly question. Why do you want the £ symbol in every instance of currency? Put it in the top cells, as "AMOUNT £" and format the cells to numeric, 2 decimal places. If I recall correctly, if you use currency there is always the danger that the currency will change. It takes more room too.

If you want to copy down it is worth remembering that selecting the black box at the corner of the cell in use so that the curser becomes a big + enables you to just pull down the values as far as you want. A $ after the character, as in @winjim's D2=if(isblank(B2),"",SUM($B$2:$B2)), means the $B$2 does not change when you do this but the 2, in $B2 will.

BTW, if you go to A2 and then select the Window>Freeze checkbox the heading will remain visible however far you write down the column.

If you know all this, sorry, but you did say you didn't know much.

 

[PeteXXX]

I'm happy with it as it is, thanks, and I'll probably do the Freeze option when the cells are further populated. It's a good idea.
Cheers for the suggestions though.

 

[AndyRM]