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

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.

Sample data

• Then, to calculate the total value of the shorts, you have to use the below given formula in the formula bar.

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

Use the Formula

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

Output

• After that, to calculate the total value of the hoodie, you have to use the below given formula in the formula bar.

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

Use the Formula

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

Output

• Then, to calculate the total value of the T-shirt, you have to use the below given formula in the formula bar.

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

Use the Formula

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

Output

• After that, to calculate the total value of the hat, you have to use the below given formula in the formula bar.

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

Use the Formula

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

Output

• Now, to calculate the total value of the Sandals, you have to use the below given formula in the formula bar.

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

Use the Formula

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

Output

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!! *And Excel Formulas *!!

Read Also:

• Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS
• Excel Formulas to Calculate the Sum of the Time with SUMIFS Function!!
• Formulas to Sum the Values by Year using SUMIFS!!
• Excel Formulas to Sum the Values with Multiple Criteria and OR Logic!!
• Formulas to Sum the Values with Horizontal Ranges using SUMIFS!!