How to use classification summary in Excel

Will you use the sub-summary function in Excel? Recently, I came across a job and used the "Classification and Summary" function, and I feel that it is very easy to use, so I will share it with you.

Method steps.

Note: Before categorizing and summarizing, you need to sort the data in ** once.

1. First of all, let's take a look at the ** data to be classified and summarized.

2. First, sort the data with "payment fee type" as the keyword, and then sort the sorted effect.

3. Then select any cell in the data area, and click "Classification Summary" in the "Data" - Classification Display group.

4. In the pop-up Classification and Summary dialog box, select the column header in the Classification Field box. Let's select "Payment Fee Type"; In the Summarize By box, select the method you want to summarize, and select Sum. In Selected Summary Items, you can select one or more fields to be sorted and summarized, select an item for Actual Ticket Amount, and then click OK.

5. Click on the classification and summary results generated after confirmation, and we can find that the total amount of travel, transportation, others, mail, and entertainment has been counted separately.

6. What if we are only interested in summary information and don't want to see detailed data? Easy to do! See?

On the left, there's a button like a minus sign, so let's click on it and see what happens. How about the final result after clicking on it, the goal is much clearer, right?

7. Some people say, I don't want to classify and summarize, do I want to withdraw the summarized data step by step? No need to drop, select "Delete All" and it's OK.

First, classify according to a certain standard, and then summarize the relevant data of each category on the basis of summing, averaging, numbering, maximum, and minimum on the basis of classification.

How to classify and summarize in Excel.

Classification and summary in Excel refers to a kind of data summary of the data after the basic data management in the worksheet is carried out, and then the data is organized and clarified on the basis of using the functions provided by Excel itself. Let me bring you the Excel 2010 classification method.

The steps of Excel 2010 classification and summary are as follows:

1.Open Excel**, select the content that needs to be inserted into the subdivision, and click "Data" "Hierarchical Display" and "Classification Summary" in the toolbar

2.Then we can set up the relevant subtotals, and click OK after the settings are completed.

3.Finally, we can see the effect of inserting the work summary in **.

1.Excel 2010 how to use subtotalization.

2.2010 excel how to classify and summarize.

3.Excel 2010 how to classify and summarize.

1. First of all, you must sort the data to be summarized, select all the data, and click "Data" - Sort "- the main keyword is set to "Name" - the sorting basis is set to "Cell Value" - the order is set to "Ascending" - OK. The keywords here are related to the method you want to summarize, you can choose which keyword you want to classify, and here you want to summarize everyone's sales, so choose "name" as the sorting keyword. As for the order, it is okay to be in "ascending" or "descending" order.

2. Select the ordered data and click "Data" - Classification and Summary. There are multiple settings on this interface, the classification field indicates which field you want to summarize for, here you should select the keywords sorted in step 1; There are several statistical methods: sum, count, average, maximum, minimum, and product. The summary rule has several column headings in **, and which one you choose indicates which one you want to count for. In this example, the classification field is set to "Name", the summary method is set to "Sum", the summary rule is set to "Sales", and the "Summary result is displayed below the data".

3. In this way, the classification and summary will be made. There is a row under each name that summarizes the total sales of this person, and there are more grading marks on the left side of the interface, and you can click on the number in it to shrink or data, for example, click on the number "2", it will shrink all the original data, and only the summary results will be displayed; Clicking on the number "1" will only show the "Total" result.

4. If you want to use multiple rules to summarize, repeat step 2 above, and leave "Replace current summary" unchecked in the summary setting window. If you don't want to be sorted and summarized, click "Data" - "Classification Summary" and "Delete All".

You can insert a subsummary level for a set of data, as shown in the following example.

Each change in the motion column.

.A breakup of the Sales column.

Sort the columns that make up the group.

For more information about sorting, see Sort data in a region or table.

On the Data tab, in the Drill Down group, click Subtotal.

In the Categorical Field box, click the column for which you want to calculate the subtotal. In the example above, you should select Motion.

In the Summary by box, click the summary function that you want to use to calculate the subtotal. In the example above, you should select Sum.

In the Selected summary items box, select the check box for each column that contains the value for which you want to calculate the subtotal. In the example above, you should select Sales.

If you want to automatically paginate by each subtotal, select the Pagination per set of data check box.

To specify that the summary line is above the detail line, clear the Summary results appear below data check box. To specify that the summary line is below the detail line, select the Summary results appear below data check box. In the example above, the check box should be cleared.

Optional) You can use the Classification Summarization command again by repeating steps one through seven to add more subtotals using different summarization functions. To avoid overwriting an existing subtotal, clear the Replace current subtotals check box.

How to classify and summarize in Excel.

How to sum excel classification? You can click Data -》Classification and Summary, set the fields and summary methods of the classification, and the summary items can be summed up by classification.

How to classify and summarize data in Excel.

1. Sort the data first.

2. Select the cell area point data - classification summary.

3. In"Categorical fields"Choose what to classify, and choose one of the "summary method" such as summary, counting, average, etc. (according to your own requirements). Are you sure.

How to classify and summarize in Excel.

How to use WPS** subtotals.