Keeping a Total to Update with each new entry

[msussan]

So I am trying to use a spreadsheet to maintain a count of each item in a storage room. I have an item name in cell A5 and in E5 I have how many were counted. Now I want to be able to add and/or subtract from that number as new product is added or subtracted from the room. I have created a drop-down cell in F5 so that I can just choose the value we are adding and the total will update.

My issue is that the total "forgets" the old number in the drop down as soon as I change it and the value is off. Is there a way to make it so that if I have "5" in cell E5 and add "5" from the drop down in F5, the total will say 10; AND THEN, I can choose "5" from the drop down again and the total will be "15"? I would also like to have a subtraction cell in G5 for when things are removed. Thanks guys, hope you can help, it's really been kicking my ***.

[ChemistB]

You'll need VBA to do this because, as you said, the formulas do not have any memory of what came before. I am assuming that it won't just be in row 5 so I set up this code for 5:100. Adjust to fit your ranges. Right click on the sheet tab > View code and paste this code in.
I am attaching an example sheet also.

Please Login or Register  to view this content.

[msussan]

So your code works, however it's just a bit different than my goal; I believe I explained it poorly. It seems to be placing the "total" into E5. That is actually already populated with a constant number. F5 and G5 are the addition/subtraction respectively, and H5 would be the total. Also, should I have to skip a range for a new group of items, how would I go about doing that? Is it as simple as adding an additional range to the code, or would I have to have a new set of code for each new range? I've attached an example of what I'm looking at doing. Thanks!

[ChemistB]

The Offset part of the code is (rows, columns) so for F to H is (0,2) and for G to H is (0,1)
Yes, should just be able to add code ofr the additional ranges, your example didn't exactly show where or how these ranges would differ so couldn't give you an example.

[msussan]

I don't suppose you could tell me how to mark this as solved? I can't find the edit first post selection.

[msussan]

Got it thanks for all your help!