First, open the excel table, select the data-data classification option at the top of the page, and then select the column to be classified in the classification field of the pop-up dialog box. The summary method is summation. Finally, check the column to be summarized in the selected summary item, and click OK.

Excel advantage

Data perspective function, a data perspective performance produces 10 kinds of reports, just blowing off dust. Easy to use, novice, as long as you carefully use the guide 1-2 hours, you can just hit the road. Statistical analysis is actually included in the data perspective function, but it is very unique, and the commonly used inspection methods can be done with one click.

Chart function, which is almost a unique skill of Excel, other programs can only turn around and commit suicide. Advanced filtering is an advanced query function provided by Excel with simple operation. Automatic summary function, this function is available in other programs, but Excel is simple and flexible.

Full-featured: it can handle almost all kinds of data. Easy to operate: menu, window, dialog box, toolbar. Rich data processing function, rich drawing function: automatic creation of various statistical charts, rich automation functions: automatic correction, automatic sorting, automatic screening, etc. Fast and accurate operation, convenient data exchange ability, and new Web tools.