Hi I'm a bit of an Excel virgin.
I'm trying to set up a formula so a particular cell will show a running
total of stock.
exampe
A1 quantity recieved today
A2 total quantity recieved =A1+A2
A3 quantity dispatched today
A4 total quantity dispatched =A4+A3
A3 shows current stock level. = A2-A4

However, everytime I edit a cell e.g quantity recieved today, all formulas
update and not just the modified cell. how can i stop this happening?