Summation of multi-table data in Excel

Many units will count the data of that month every month, and the data for the whole year will be collected by the end of the year. Do you know how to sum up? Today, Mr. Wang is going to share with you two of the easiest ways.

As shown in the following figure, each month's data is recorded on a separate worksheet.

1. Function Summary Let's create a new worksheet, then record the title row and column, select the blank data area, and then enter the formula:

= sum ('*'! B2) finally press "Ctrl + enter" to quickly summarize and sum the annual data.

Note: this method is suitable for all cases where the positions of header rows and columns are fixed, otherwise there will be problems.

2. although it is fast to use formula summary in merger calculation, it also has some defects. If we add a product or new staff when we record it, or if the location changes, we won't be able to get the correct results.

However, the method introduced below can completely solve these problems. We don't have to worry about new people, products, or location changes, and we can quickly complete the summation.

Let's first create a blank worksheet, then go to "data"-"data tools"-"merge calculation", select "Sum" in "function", click the button next to "reference location", select the table in "January" worksheet, click "add" in "merge calculation"; continue to click the button next to "reference location", select the table in the February worksheet, and "add" Add all the following tables to the merge calculation in turn.

After all is added to the "merge calculation", we check the "first row" and "leftmost column", and then we can sum up all the data for January and December.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi