# running total formula for inventory

1. ## running total formula for inventory

i hope i posted this in the right place i am new here.
here is what i need i want to a running total that as i add it inceases and as i use the item it will subtract from the starting inventory example

i have 5000 bolts and use 1000 it shows 4000 then when i add 500 it shows 4500 and so on.
k4 would be my starting total cell h4 would be my subtract cell and i4 would be my add cell. i hope i explaned this right
this is for my nut and bolt inventory in my shop i am trying to make it simple for the guys that work with me so we know what we are using and when we need to order more.
thank you so very much
jeff

2. ## Re: running total formula for inventory

Would you not just use this formula in another cell?

=k4-h4+i4

If you wanted something a little more complicated maybe an example would be helpful

cheers

3. ## Re: running total formula for inventory

well i need it to hold the running total tho i guess i didn't explain myself very well sorry.
with a starting quanity. so if i 5000 and the add 50 i get 5050 and it i add another 200 i get 5250 and if i add another 200 i get 5450 then i use 100 it shows 5350 and so on i hope this helps explain better
thank you so very much
jeff

4. ## Re: running total formula for inventory

This is what I imagine you mean. Let me know if that's right.

Cheers

5. ## Re: running total formula for inventory

i'll try to add a example to my post tommorrow that will hopefuly make more sense i just have to get to bed i need to be up early and i will post it.
again thank you for taking the time to help me with this it is probably very simple but i am not do a good job at explaining myself very well lol
thank you
jeff

6. ## Re: running total formula for inventory

i am not sure how to upload a working excel file but here is a picture of what i am trying to do

7. ## Re: running total formula for inventory

you can upload the excel file the same way as the picture
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

8. ## Re: running total formula for inventory

thank you that was easy and i hope this helps explain what i need.
i just need when you add to count for the total to hold it and every time i put another amount in the same cell and continue to incease and the same with when i minus inventory
thank you so very much
jeff

9. ## Re: running total formula for inventory

If you want to be able to just keep adding data to H3 and I3 (over-writing what was there before) etc, and have K3 update according, there is no regular formula that will do that for you - a cell can contain either data or a formula, not both.

IF that is what you want, maybe some-one can write some VBA code for you

Alternatively, take a look at the attached and see if that is something you can work with? You just keep entering data downwards in A:C and M2:O8 run the balances for you
I included data validation in A to eliminate typos, Im sure you have far more than just the nuts and bolts you listed, so you can just increase the DV range (let me know if you dont know how)

10. ## Re: running total formula for inventory

this might do the job i am going to try it out and see how it goes.
thank you so very much for all your help
jeff

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1