The hotel needs to calculate the cost of each dish. Each dish has many ingredients, and the unit price of the main ingredients is in a separate table. Is there any way to show it directly?

Your form is completely manual, which can hardly be used for data calculation and analysis, and can only be used as a voucher for bookkeeping.

See you this form should belong to a one-time calculation and analysis form, such a form requires more rigorous, certainly not so simple to make, it is recommended to adjust the form to:

1, material price, and establish a separate material price list (very convenient for subsequent reference and adjustment). The content is very simple, mainly including two columns, namely, product name and price (date can be added if there is any change to facilitate cost accounting in different periods). But we must pay attention to unifying product names and units. In order to facilitate the subsequent use, we can add materials with different material grades, such as yellow beef, super yellow beef, imported beef, etc., and list them separately. The unit corresponding to the price is suggested to be unified (it can also be based on actual habits, but it must be unified. For example, in the previous analysis table, kilograms must be used here and grams must be used here. To avoid confusion or forgetting, you can add a unit column to this table.

2. Adjust the existing table format. It is suggested to modify the table vertically, that is, the first row is the name of the dish, and each dish name uses two columns of cells, one column is the name of the material, and the other column is the consumption (the consumption unit corresponds to the unit in the material price list, but only the data is registered, not including the unit, such as 2 kg, so it is only registered as 2), (of course, it is possible without modifying the format, which is a bit troublesome in the future), and then the cost can be summarized by using the following sumproduct function.