Forum Discussion
Formula Error For Inventory Sheet
Afternoon All, Wondering if someone can assist. I am needing what is probably a basic cell formula, but cannot get it to work. I will try to describe what i want the cells to do in as much det...
ShaunJM HI,
Given that the stock list was not provided, my suggestion is just based on the "Total Quantity" of Locations A, B and C. It's a basic formula that allows you to enter the number of stock in B8 / B9 / B10 and then B6 would be updated automatically. C6 = C5 + B8 and D6 = D5 + D9.
Hope it can help you, please feel free to provide the more details if it is not fit for you.