I have a workbook for tracking my inventory in real time.
I want to have my inventory crew count and add the data in line along with the receiving and departing shipments of 12oz bottles. For instance, when we Start the week with 343,520 bottles. This number is totaled out and placed in J5. The next day we check the count and enter in 343,520 and is placed in J6. The totals of the rows pallet and layer count are sumed for each row (or action) and placed in the L column.
To get the current total on hand, A2 sums L5:L47. However, I do not want the total to reflect as 687,040. Instead I want the equation to reference Column A and see that A6 says 'Inventory' or 'Inventory Count' and know to skil J6 when A2 (Total Bottles on hand) is summing L5:L47.