Sum of profit

[Leo2324]

Hi
Im trying to set up a spreadsheet where in one column I have each day of the month, against each day I'm putting in my final figure on a betting site, e.g...[TABLE="width: 150"]
<tbody>[TR]
[TD][/TD]
[TD]Start with £20[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD]£25.60[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD]£10.00[/TD]
[/TR]
[TR]
[TD]Weds[/TD]
[TD]£15.00[/TD]
[/TR]
[TR]
[TD]Thurs[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Profit/loss[/TD]
[TD]-£5[/TD]
[/TR]
</tbody>[/TABLE]
So on Monday for eg. I made a profit of £5.60, tues I lost £15.60 etc.

For The profit/loss cell I need a formula for which will show me if I've made a profit or loss overall, is there a way of doing this?

Thankyou for any help

 

[mrshl9898]

It sounds like you just need todays amount - yesterdays amount

so =B2-B1

 

[jtakw]

Hi,

And for your final Profit/Loss cell, assuming it's B31, use your last day cell, assuming it's B30, minus your "Start" amount cell, assuming it's B2, something like:

In B31, =B30-B2