I have an excel sheet that tracks the starting on hand balance of many inventory items and then remaining qty on hand as shipments are planned. I am trying to use this report to further evaluate how many total boxes we have on hand on any given day. Ideas how to format or calculate this? Current sheet is formatted like the following to remove all unnecesary information.
Activity Date -- Remaining Qty On Hand -- Calculated Boxes On Hand Remaining
This works good, but what I need is a way to summarize this report so that it adds the total of all boxes remaining on hand for all items and sorts by date. We also need it to add a value on hand even if there is no activity for a certain item on every single date.