Shown as follows: Figure 6 Add the 2013 Data cells area Step 8 Press OK.Then the result of consolidation will be displayed in the target worksheet.
Kutools for Excel with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. After installing Kutools for Excel, please click Enterprise Combine. In the Combine Worksheets wizard, select Consolidate and calculate values across multiple workbooks into one worksheet. On step2 of wizard, all the opened workbooks and worksheets are listed in the list boxes, you can click Add button to add other files or folders that you want to consolidate.In Kingsoft Spreadsheets 2013, you can use consolidate feature to combine data in different worksheets more easily.There are two ways to consolidate data, one is to consolidate data by category, and the other is to consolidate data by position.Shown as follows: Figure 2 2013 Data worksheet Step 3 Click the Total Sales worksheet tab, and input row and column labels. The Consolidate dialogue box will open and show as below: Figure 4 The Consolidate dialogue box Then do the following: Figure 5 Add the 2012 Data cells area Step 6 Click Add.Shown as follows: Figure 3 Total Sales worksheet Step 4 Choose the Total Sales worksheet as the target worksheet. Then the range will be added in the All References box. Add the range of B3: D9 in 2013 Data in the All References box.