Easy spreadsheet help

[robfosters]

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

 

[robfosters]

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.?

 

[robfosters]

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.