Methods of merging and summing data in multiple tables in WPS
Can the WPS table realize the merge and sum calculation of multi-table data? This article explains in detail the method of merging and summing data in multiple tables in WPS.
- Open the WPS worksheet that needs to be consolidated.
Methods of merging and summing data in multiple tables in WPS
- Select a cell at any point in “Sheet3”, switch to the “Data” tab, and click the “Consolidate” button.
Methods of merging and summing data in multiple tables in WPS
- The “Consolidation Calculation” dialog box pops up, select the data area in “Consolidation Table 1”, and then click “Add”.
Methods of merging and summing data in multiple tables in WPS
- Select and add the data in “Merge Table 2”, then check the “Leftmost Column”, and click “OK”.
Methods of merging and summing data in multiple tables in WPS
- At this time, the data of table 1 and table 2 are merged into “Sheet3”.
Related: