1. First, open the excel20 10 table and click the cell to edit.

2. Click "Data" in the menu bar and find "Sort";

3. Click Sort to open the dialog box. We click the triangle arrow of the main keyword and select the product name.

4. After clicking OK, we found that all kinds of items have been automatically classified;

5. Next, click "Formula" in the menu bar to automatically sum;

6. We chose all kinds of cells.

7. Sum separately.