Current location - Recipe Complete Network - Catering franchise - How to count and summarize the number of vegetables in excel tables and display individual vegetables in cells?
How to count and summarize the number of vegetables in excel tables and display individual vegetables in cells?
The steps are as follows:

1. Add two columns to the table, one is the name of the vegetable and the other is the quantity.

2. Add a row at the bottom of the table for summary.

3. Use the SUMIF function in the summary line, and the syntax is SUMIF(range, criteria, [sum_range]), where: range: the cell range of the dish name to be matched, which can be a single cell or a region. Condition: The name of the vegetable to be matched, which can be a text string or a cell reference. Sum_range: the cell area where the quantity to be summarized is located; If omitted, it will be the default range.