Excel warehouse statistics table, material inventory summary table (incoming, outgoing and incoming), and more than three delivery tables. How to summarize the delivery of three tables into a summary table? I. It is suggested to establish an inventory file: details such as model, product name, specifications, etc. It is best to use code, which should be unique and easy to operate. Combining index+match and sumif can meet your needs.

2. Only the daily receiving and dispatching details are entered into a table, and then summarized into a receiving, dispatching and storing summary table through the sumif function (the details and summary table are consistent with the inventory file details established above).

Third, what is important is the logic of thinking; Templates are available (including instructions). If necessary, I can leave the oil fragrance and give it to you.

The following picture styles are sample tables made according to the above description: If there are multiple such tables, you only need to summarize the data and set the function sumif directly; If there are many tables (the same style), you can get the inventory summary of all warehouses. (For reference only)

1, plan title style:

2. Ways of receiving, sending and storing summary tables: