How to extract and sum data corresponding to the same name

Method to extract and sum data corresponding to the same name: 1. Open the Excel table that needs to be operated; 2. Select a blank cell; 3. Click the "Data" tab and click "Merge Calculation" ; 4. Set the "Reference Position" to the entire data area; 5. Check the "First Row" and "Leftmost Column" and click "OK".

The operating environment of this article: Windows7 system, WPS Office2019, Dell G3 computer.

How to extract and sum the data corresponding to the same name?

Open the Excel table that needs to be operated. The following figure shows the original data area, in which there are four area names and each Each region name corresponds to multiple pieces of data. We need to summarize and sum the total monthly sales in each region.

First, select a blank cell outside the data area, as shown in the figure below, to display the summary and summing results.

Click the "Data" tab and click "Consolidate Calculation", as shown in the figure below.

Open the consolidated calculation dialog box, where the "Reference Position" is set to the entire data area (including the title), check "First Row" and "Leftmost Column", and finally Click "OK", as shown in the figure below.

The total monthly sales volume of each region is summarized and summed, and the final effect is shown in the figure.

Recommended study: "Excel Tutorial"

The above is the detailed content of How to extract and sum data corresponding to the same name. For more information, please follow other related articles on the PHP Chinese website!