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.

  1. Open the WPS worksheet that needs to be consolidated.

Methods of merging and summing data in multiple tables in WPS

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

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

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

  1. At this time, the data of table 1 and table 2 are merged into “Sheet3”.

Related:

Windows key

Buy Office key

Leave a Reply

Your email address will not be published. Required fields are marked *