Excel Formulas to Sum multiple tables in Excel office 365!!
Tags: excelformula, excelformulas
Published: 2021-10-29 03:18:57

---
title: Excel Formulas to Sum multiple tables in Excel office 365!!
published: true
date: 2021-10-28 10:39:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-sum-multiple-tables-in-excel-office-365/
---

For Example, we have a list of values, and we want to [sum](https://geekexcel.com/sum-function/) 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](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**](https://geekexcel.com/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.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-63.png)<figcaption>Sample data</figcaption>

- Then, to sum a total in multiple tables, you need to use the following **formula** in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

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

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-Formula-17.png)<figcaption>Use the Formula</figcaption>

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-1-6.png)<figcaption>Output for amount</figcaption>

- After that, to sum a total in multiple tables, you need to use the following **formula** in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

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

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-Formula-1-1.png)<figcaption>Use the Formula</figcaption>

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

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-2-5.png)<figcaption>Output 2</figcaption>

**Check these too:**

- [Excel Formulas to Calculate SUMPRODUCT of the List](https://geekexcel.com/excel-formulas-to-calculate-the-sumproduct-of-the-list/)
- [How to Sum Bold Values or Numbers Only in Excel Office 365?](https://geekexcel.com/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](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[Excel Formulas to Lookup Two Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-lookup-two-tables-with-vlookup-function/)**
- **[Excel Formulas to Merge the Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-merge-tables-with-vlookup/)**
- **[How to use VLOOKUP to Match Two Tables with Excel Search Box?](https://geekexcel.com/how-to-use-vlookup-to-match-two-tables-with-excel-search-box/)**
- **[Easy Shortcuts for Tables and Filters Options in Excel 365!!!](https://geekexcel.com/easy-shortcuts-for-tables-and-filters-options-in-excel-365/)**
- **[How to Merge Tables By Matching Columns From Two Worksheets in Excel?](https://geekexcel.com/how-to-update-merge-tables-by-matching-column-from-two-worksheets-workbooks-in-excel/)**