1.workbook has more than one worksheet, column A and column B have similar data, the number of rows is different.2. Select the "Summary" table cell A1, click on the data - merge calculations.3. The upper left corner of the selection of the appropriate mode of operation, in this case, the "summation". As shown in the figure below, click the Select button to select data. 4. Select the first worksheet data, and click the Add button. 5. Order will be added to the other worksheet data. 6. As the first line of the original data is the title, and to the A column of data classification summary, so check the following two options. 7. Determined to be in the "summary" table Generated by each of the "number" of summary summation data. 8. If you check the box to create a link to the source data will eventually return to the link data and summarize. 9. Completed the summary effect is as follows. 10. Click on the plus sign next to each person you can see the summary of the data is from which worksheet which cell references to come.