Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to consolidate data in WPS Spreadsheet
Uploaded time: August 31, 2021 Difficulty Beginner
How to consolidate data in WPS Spreadsheet
How to consolidate data in WPS Spreadsheet
In daily work, we often need to summarize and calculate some related data.
By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together!
Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees.
1. Create a summary sheet in Spreadsheet.
2. Select cell A1 in the summary sheet, and click the Data tab-and then the Consolidate button in turn. After the dialog box pops up, select a calculation method in the function drop-down list. Since we want to calculate the total sales volume, so we choose Sum.
3. Click Reference, and select the needed data areas in different sheets.
4. Click the Add button, then add the data areas that need to be merged in different sheets to the All References Locations list box.If you want to delete the added data area, just click the Delete button on the right.
5. Also, we need to remember to check the Top row and Left column of the Label location. If not doing so, WPS Spreadsheet would only count the values, while the salespersons' name could not be matched.
Also Read:
- 1. How can we use the data validation feature
- 2. How to quickly locate and replace data
- 3. Conditional Formatting for data virtualization
- 4. Change horizontal data to vertical and make data clearer
- 5. How to insert a chart and edit the chart data in WPS Presentation
- 6. How to group data in a spreadsheet
Does this video help you?