In daily work, many partners use Excel to create tables, which is very convenient to operate. So during the operation, if you want to sum across tables, how should you do it? Detailed steps are explained below.

Taking the table below as an example, we need to calculate the total of the previous one and two months in the summary table.

​​In the summary table, enter =SUM(function

Click on the table that requires the sum for January, and press SHIFT at the same time to click on February, so that all the two summation tables are added.

​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​?

After completion, press CTRL+Enter to complete the sum. Finally, pull down in the summary table to complete the filling. A cross-platform sum table is ready.

The above explains the steps for summing across tables in Excel. I hope friends in need can learn it.