DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

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

#excelformula #excelformulas

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])
Enter fullscreen mode Exit fullscreen mode

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])
Enter fullscreen mode Exit fullscreen mode

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])
Enter fullscreen mode Exit fullscreen mode

Use the Formula

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

Output 2

Check these too:

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:

Top comments (0)

Read next

anil_csimplifyit_905c profile image

Selecting the Right Quality Management System (QMS): Understanding Your Testing Needs

Anil @ C Simplify IT -

devactivity profile image

Agile Methodology Retrospective: Making Sense of Your Sprint Chaos

Oleg -

mspilari profile image

All About Proxies: Types and Implementing a Reverse Proxy with Load Balancing Using NGINX and Docker

Matheus Bernardes Spilari -

edgaremmanuel profile image

Implementing Domain Driven Design - Day 2

DevByJESUS -