adding and subtracting from one total number.

[Jakeswingo]

hi,
i am doing stock inventory at my work.
what i want to do is have one total value (eg 2000). then depending on what comes in i can add or subtract from that number but i dont want to keep going down my page with for example. 3/05/17 received 1000, 4/05/17 used 1000. i just want to be able to type into a cell + 1000 and it adds it to my total boxes. or - 1000 boxes and that takes away from my total.
also once i delete the value in the + or - box the total number stays either 1000 more or less depending on if i have either added or subtracted.
eg. total = 2000
+ 1000
= 3000
(delete +1000 out of box)
total =3000
- 2000
= 1000
(delete 2000 out of box)
total = 1000

please help me! can this be done on excel

[humdingaling]

from an information audit perspective wouldnt you want to keep those +/-?

here is something i knocked up for someone previously you could adapt

[Jakeswingo]

thanks for that but it didnt help.
i want one number which is my total boxes. then somewhere i just enter in +1000 and it adds to my total boxes and then that could coralate down into if i have 20 boxes how much tape do i use, have many stickers.
also i want to be able to change individual amounts such a amount of tape when it arrives and then if as i use boxes it takes off my total amount of tape and stickers ect.

[avk]

Kindly attach your data structure file to get clear idea.

[humdingaling]

that sounds nothing like your original request
im with AVK i need to see what you are implying
as it now sounds like you want some kind of Bill of material as well