How to classify and summarize Excel data?
How to classify and summarize excel data:
Open Excel and create a blank workbook.
#Enter data that needs to be classified and summarized. When entering data, do not use merged cells even if they are cells with the same items.
The above data, for example, needs to summarize the sales volume of each salesperson and the sales volume of each department. Place the cursor in the data cell and click "Data" - "Subclassification".
In the window that opens, select the sales department for the category field, select sum for the summary method, select sales volume for the summary item, and select the other two items by default. Click OK.
This achieves summary by sales department.
Execute the classification summary again. In the window that opens, select salesperson for the classification field, summation method, check sales volume for the summary item, and uncheck "Replace" Current Classification Summary", click OK.
This further enables aggregation by salesperson.
#Click the grading button on the left side of the worksheet to view the summary results of each level.
excel basic tutorial"
##
The above is the detailed content of How to classify and summarize Excel data?. For more information, please follow other related articles on the PHP Chinese website!