Ok I want to keep track of current stock but have a few different places stock can be in put and taken out.
I have an Inventory sheet with In & Out column (+=added stock and -=taken away stock)
Manual Sale sheet with Quantity Sold column
Play sheet with Quantity Sold column
I originally typed =[Levels!Inventory In & Out] + [Manual Sale!Quantity Sold] + [Play!Quantity Sold] but its not working its only showing “Levels!Inventory In & Out , Manual Sale!Quantity Sold , Play!Quantity Sold”
How do I fix this