Easy spreadsheet help

robfosters · 5 Oct 2015 at 15:28

I've tried to do this myself but I am utterly useless at it.

If you look at the table below, all I want is for the profit net column to update in the cell next to the profit loss that I put in. I autosum'd it, but it just updates cell M3 every time. I want them all to update so I can keep a track of how the balance is going up and down.

If I haven't made things clear enough, let me know. Thanks

Jim99 · 5 Oct 2015 at 15:30

I've read what you said three times and have no idea what you're trying to do. Hopefully someone else gets it, but if not, I'd say you might need to explain a bit more.

robfosters · 5 Oct 2015 at 15:40

Jim99 said:
I've read what you said three times and have no idea what you're trying to do. Hopefully someone else gets it, but if not, I'd say you might need to explain a bit more.

See the cell with green border round it? How do I put a profit/loss in there and get the cell next to it to update instead of just updating the M3 cell all the time.?

divebod · 5 Oct 2015 at 17:08

If that green border cell is L4, you want a formula =sum($M$3:$M4) in it. You can then copy that formula down column L. It locks each cell from M3, summing to M4, M5, M6...

robfosters · 5 Oct 2015 at 17:26

Thanks for your help, but I cant do it. I will just autosum it each time I put a new entry in. I'm only putting a couple in a day anyway.

Luke_Bowman · 5 Oct 2015 at 17:29

Surely you can just use '=m3' for the cell you want to keep updated?

Or am I misinterpreting?

divebod · 7 Oct 2015 at 17:58

I think I now understand.... You will input numbers in column L and want column M to keep a running total of column L. If so then you should put =sum($L$2:$L3) into cell M3 and then copy this down column M. Hope this gives you want you want.