Excel Formulas to Sum multiple tables in Excel office 365!!

For Example, we have a list of values, and we want to sum the values in multiple tables means what would we do? In this article, I introduce some formulas which can quickly sum multiple tables in Excel Office 365.

To sum multiple tables, you can use a formula based on the SUM Function. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• The below formula will help you to sum multiple tables in Excel.

=[SUM](https://geekexcel.com/sum-function/)(Table1[column],Table2[column])

Syntax Explanation

• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• *SUM * – The SUM function adds values to the cells.
• *Table * – It contains list of values.

Practical Example

Let’s consider the below example.

• For instance, you have to create a sample data in Excel.

Sample data

• Then, to sum a total in multiple tables, you need to use the following formula in formula bar.

=[SUM](https://geekexcel.com/sum-function/)(Table1[Amount],Table2[Amount])

Use the Formula

• Now, you have to get the result for amount as shown in the below image.

Output for amount

• After that, to sum a total in multiple tables, you need to use the following formula in formula bar.

=[SUM](https://geekexcel.com/sum-function/)(Table1[Amount],Table2[Amount])

Use the Formula

• Finally, you have to get the result for Qty as shown in the below image.

Output 2

Check these too:

• Excel Formulas to Calculate SUMPRODUCT of the List
• How to Sum Bold Values or Numbers Only in Excel Office 365?

Summary

In this guide, you can get some clarification about the formulas ** ** to sum multiple tables in Excel Office 365. If you have any other ideas or questions , do share them with us here in the comment section below. Thank you so much for Reading!! For more updates, check out our website Geek Excel!! *And Excel Formulas *!!

Further Reference:

• Excel Formulas to Lookup Two Tables with VLOOKUP Function!!
• Excel Formulas to Merge the Tables with VLOOKUP Function!!
• How to use VLOOKUP to Match Two Tables with Excel Search Box?
• Easy Shortcuts for Tables and Filters Options in Excel 365!!!
• How to Merge Tables By Matching Columns From Two Worksheets in Excel?