Excel cross-sheet sum operation steps

Time: 2022-03-02Source: Huajun Software TutorialAuthor: Ai Xiaomo

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.

Related articles更多>>

• Graphical tutorial on converting negative numbers into positive numbers in batches in Excel
• Specific instructions for copying formulas in Excel
• Basic steps for Excel to prompt for duplicate items
• Excel table prompts to solve the problem when sending commands to the program
• Tips for solving incorrect values ​​when using the VLOOKUP function in Excel
• An explanation of how to clone a table in Excel
• Detailed instructions on how to automatically fill in working days in Excel
• Tutorial on how to reverse text in Excel
• Graphical step-by-step description of splitting addresses in Excel
• Detailed explanation of how to use the column function in Excel

Popular recommendations

• 

  7Zip Chinese version for Mac

  Version: latest versionSize: 1.76 MB

  7Zip Chinese version Mac official version is a compression and decompression tool suitable for use on the Mac platform. The latest version of 7Zip Chinese version for Mac supports 7z, Rar, Tar, B...

• 

  Bandizip

  Version: 7.31Size: 34.8MB

  Bandizip The official Mac version is a powerful Mac online compression and decompression tool. The latest version of Bandizip has a variety of convenient functions and is suitable for Mac...

• 

  Sogou input method Mac version

  Version: 6.15.2Size: 140.85MB

  The Mac version of Sogou Input Method inherits the super word grouping algorithm of PC Sogou Pinyin Input Method. It has a large vocabulary, fast typing, and smooth hand feel. Mac Sogou Input Method can also be used directly...

• 

  Sogou Wubi input method for Mac

  Version: 1.4.0 latest versionSize: 41.86 MB

  The latest version of Sogou Wubi Input Method for Mac is a Wubi input tool created by Sogou for users. The official version of Sogou Wubi input method for Mac uses Wubi + Pinyin...

• 

  Sogou Wubi

  Version: v1.4.0Size: 41.86 MB

  Sogou Wubi official version is a Wubi input tool created by Sogou for users. The official version of Sogou Wubi can not only input pure Wubi, but also pinyin...