If your requirement is to show remaining inventory, and you have an reliable input on what has been removed from inventory, then there should be several ways to get where you want to be. Since I have no format to look at, this suggestion may fail to meet your needs.

Once way would be to have a tab just for inventory. List dates in column A going down to show activity. Label what an entry is for , generally related to a meaning for "used", "purchased", or maybe adjustments for missing or spoiled. Begin with a row for beginning inventory. So, now you may have a list of 309, -10, -5, ... the sum of which is your current "book" inventory. My preference for this may be to leave a frew rows at the top, lock the rows so I can see my column headers and us the SUM function on the column with inventory numbers. This way you can refer to a fixed location if you are using this in another tab.

Hope this helps or provides a spark that helps you.

Do you want that total be the source for the next use? In other words, do you want to subtract the 10 cases on Monday to get a balance of 299, then open the program on Wednesday and see that 299 balance as your starting point? I don't know how you can do that in Excel without some serious VBA.

A simple Excel solution is:

Top row: starting inventory (manually entered)

Next row: current balance (formula = starting inventory - sum(removals)

Subsequent rows: individual removal entries.

Or you could try a pre-built database solution such as this [free] one: http://www.freewarefiles.com/program_8_88_12345.html

## How to set up a formula in Excel for calculating inventory

For example I have 309 cases of Beef patties at the beginning of the week and 10 cases are used on monday and the another 5 are used on wednesday and another 5 ae used on thursday I want to show a running balance as they are used. I tried to set up a formula to do this and the end result always showed value instead of of the balance.