DEV Community

Andrews
Andrews

Posted on Originally published at geekexcel.com on

Excel Formulas to calculate SUMIFS with Excel Table!!

#excelformula #excelformulas

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)
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.
  • *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)
Enter fullscreen mode Exit fullscreen mode

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

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

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

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

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:

Top comments (0)