I have two spreadsheets in the same workbook: Inventory List and Inventory System
In the Inventory System, I would like to be able to add the Quantity in Stock from the Inventory List (Column G) to the Quantity Received (Column K) in the Inventory System and have the Receiving Running Total in the Inventory System (Column L) reflect this.
Also, in the Inventory System, I would like to be able to subtract the Quantity Issued in the Inventory System (Column O) from the Quantity in Stock in the Inventory List (Column G) and have the Issuing Running Total in the Inventory System (Column P) reflect this.
The idea is to have running totals for issuing and receiving sorted by item (Column D) in the Inventory System and have the running totals reset when the item in the Inventory System (Column D) changes.
My formula: =AGGREGATE(9,5,INDEX(K4:K37,MATCH(D4:D37,D4:D37,)):K4:K37)
How can I revise this to accomplish this? THanks for the help.
Bookmarks