Excel Formulas to calculate SUMIFS with Excel Table!!
Tags: excelformula, excelformulas
Published: 2021-10-30 05:49:47

---
title: Excel Formulas to calculate SUMIFS with Excel Table!!
published: true
date: 2021-10-29 02:10:35 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-sumifs-with-excel-table/
---

As you have known, the  **SUMIF function**  can sum the cells that match a specified condition. Here, we will provide some formulas on how to  **calculate SUMIFS with Excel Table**. Let’s get started!! 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

- If you want to calculate SUMIFS with an Excel Table, use the below-mentioned formula.

```
=SUMIFS(Table[sum_col],Table[crit_col],criteria)

```

## 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.
- **Table ** – It contains list of values.

## Practical Example

- For example, you have to **create a sample data** in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-64-1024x506.png)<figcaption>Sample data</figcaption>

- Then, to calculate the total value of the shorts, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=SUMIFS(Table1[Total],Table1[Item],H5)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Formula-1-1024x567.png)<figcaption>Use the Formula</figcaption>

- Now, you will get the **result for shorts** as given below in the **cell I5**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-1-7-1024x504.png)<figcaption>Output</figcaption>

- After that, to calculate the total value of the hoodie, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=SUMIFS(Table1[Total],Table1[Item],H6)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Formula-2-1024x567.png)<figcaption>Use the Formula</figcaption>

- You will get the **result for hoodie** as given below in the **cell I6**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-2-6-1024x508.png)<figcaption>Output</figcaption>

- Then, to calculate the total value of the T-shirt, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=SUMIFS(Table1[Total],Table1[Item],H7)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Formula-3-1024x563.png)<figcaption>Use the Formula</figcaption>

- Now, you will get the **result for T-shirts** as given below in the **cell I7**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-3-1-1024x507.png)<figcaption>Output</figcaption>

- After that, to calculate the total value of the hat, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=SUMIFS(Table1[Total],Table1[Item],H8)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Formula-4-1024x568.png)<figcaption>Use the Formula</figcaption>

- You will get the **result for hat** as given below in the **cell I8**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-4-1-1024x503.png)<figcaption>Output</figcaption>

- Now, to calculate the total value of the Sandals, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=SUMIFS(Table1[Total],Table1[Item],H9)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Formula-5-1024x570.png)<figcaption>Use the Formula</figcaption>

- Finally, you will get the **result for sandals** as given below in the **cell I9**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-5-1-1024x505.png)<figcaption>Output</figcaption>

## Verdict

In this way, we learned how to ** calculate SUMIFS with Excel Table**. Hope that this article is useful to you. Leave a  **comment**  or  **reply**  below – let me know what you think! Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS](https://geekexcel.com/excel-formulas-lookup-table-based-on-multiple-criteria-with-sumifs/)**
- **[Excel Formulas to Calculate the Sum of the Time with SUMIFS Function!!](https://geekexcel.com/excel-formulas-to-calculate-the-sum-of-the-time-with-sumifs-function/)**
- **[Formulas to Sum the Values by Year using SUMIFS!!](https://geekexcel.com/excel-formulas-to-sum-the-values-by-year-using-sumifs/)**
- **[Excel Formulas to Sum the Values with Multiple Criteria and OR Logic!!](https://geekexcel.com/excel-formulas-to-sum-the-values-with-multiple-criteria-and-or-logic/)**
- **[Formulas to Sum the Values with Horizontal Ranges using SUMIFS!!](https://geekexcel.com/excel-formulas-to-sum-the-values-with-horizontal-ranges-using-sumifs/)**