Excuse me, what does excel mean by classification and summarization?

Categorization is to classify and summarize data by category (sum, mean, extreme, etc.), and calculate the total sales of each person as an example in the figure below.

Operation method: Select the data region, classify and summarize the data, select "Name" for "Classification Field", select "Summation" for "Summary Method", select "Sales" for "Selected Summary Item", and then click "OK", as shown in the following figure.

The result is as follows, everyone automatically inserts a summary row, and there are total rows.

Knowledge expansion: 1. Click the level button (upper left) in the above figure to display different levels of data, if you don't need to view the details of each person, as long as you view the summary number of each person, you can click "2" in the level button, as shown in the following figure:

Click the + sign to the left of a name to see the person's details.

2. Click Data >>Classification Summary", and then click the Delete All button in the Classification Summary dialog box to clear the classification summary.

Breakdowns. It is calculated according to the specified field (usually the column header in **), for example: for gas stations, there are 93 gasoline sold, etc., at the end of each month, there may be statistics on how much various oil products are sold (that is, the monthly sales of classified statistics), then it can be classified and summarized by "variety".

Before you subtotal, you must sort the fields you want to summarize so that the values with the same attribute under that field are lined together.

Sorting must be done before the subtotals can be made.

Material tools.

Excel computer.

Method. First, select the data area that needs to be sorted and summarized, and click the "Sort" option under the "Start" tab.

Please click Enter a description.

Sort the data in ascending or descending order, so that the same kind (or the same group) of data can be put together for the next step of classification and summary.

Once the data regions are sorted, click Subdivision Summary under the Data tab

Please click Enter a description.

Please click Enter a description.

Look at the specific version of excel, take 2019 as an example:

1.Click on the "Data" tab of the menu bar;

2.In the Hierarchical Display tool area, you can find the tool button for Classification Summary.

The following picture is the interface of the 2010 version, under the data, it has been similar since 2007, and the previous version is under the [data] of the menu.

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 headers 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".

Excel classification and summary method:

For example, you need to quickly calculate the sum of the scores of a class.

1.Select the columns to be summarized: Select Data from the menu and click Sort in ascending order.

2.Summary: Select Data from the menu and click Summary.

3.In the Classification and Aggregation dialog box, select the corresponding item: select the column name to be classified and summarized in the Classification field, and select "Class" here; Select the summary item and select the three columns of "Language, Mathematics and English". As shown in Fig.

4.Overview of Classification and Summary Diagrams: Follow the steps above to obtain the interface diagram after classification and summary, as shown in the following figure. Click 1, 2, and 3 on the left to display the summarized items.

5.View example: Select 2 and it will be displayed as follows: Aggregated grades for all classes by language, number and English.

How to classify and summarize in Excel.

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 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.

Enter the following formula in cell E8 and fill the formula down.

countif(a:a,d8)

Sort the columns to be classified first, then select "Classification Summary" in the data menu, in the pop-up window, select the sorted column as "Classification Field", then select the sum, count, etc. as needed, and finally select the items to be summarized, that is, the column that requires the sum or count. There are three more items at the bottom that you can choose according to your needs.

The first step is to adjust the ** "long" and "high" that need to be slagoged to be larger, as shown in the following figure:

Step 2, then select the ** that needs to be slashed, click "Right-click", select "Format Cells", select "Border" in "Cell Format", and click the "Slash" button, as shown in the following figure:

Here's how:

1.Start by selecting the columns you want to summarize and sort them:

2.Here select the expansion area and click Sort:

3.Select a data region, click Data, and select Aggregation:

4.Set the necessary fields, summary method, summary items, etc., and click OK

5.Classification summary complete:

Click a column to sort, and then click the column to sort (Data - Classification).

1. Select all data in Excel.

2. Sort the data. For example, in order to aggregate the salaries of people with the same name, the names should be sorted. The purpose of sorting is to put together the data of people with the same name for easy categorization.

The steps to sort are as follows: Click the "Data" menu and select "Sort". In the pop-up window, select "Name" in "Main Keyword", as shown in the following figure.

Click OK. 3. Select the data again.

4. Click the "Data" menu and select the "Classification and Summary" option. In the pop-up window, select "Name" in "Classification Field", select "Summation" in the Summary Method, and select "Payroll" in the "Selected Summary Item" field. Click OK.

It can be done with VBA, but it's easier to use pivot tables. I don't think it's necessary to associate your result table with other tables, if you want to do so, you can directly associate with the original table. In the related table, you probably want to use the result of the total, and you can use the function sumif or sumproduct to achieve this result relative to the original table.

Besides, every time you add content to your result table, the line number of the total result will change, which may not be very convenient.

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 data in Excel.

How to classify and summarize in Excel.