Excel Formulas to Calculate Two-way summary with SUMIFS!!

So far we have learned Excel Formulas To Lookup a Table Based On Multiple Criteria With SUMIFS. In this article, I’m going to talk about how you can use formulas to calculate Two-Way Summary with SUMIFS. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• You can use the below given formula to calculate Two-Way Summary with SUMIFS.

=SUMIFS(value,name,$G5,stage,H$4)

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.

Practical Example

• Firstly, you need to create a sample data in the Excel.

Sample data

• To build a two-way summary table that sums numeric data with more than one-criteria , you have to use the following formula in formula bar.

=SUMIFS(value,name,$G5,stage,H$4)

Use the Formula

• Now, after using the formula, you will get the result in cell H5 as shown below.

Output

• Finally, you have to copy the same formula across range H5:K7 to get the output as given below.

Final Output

Wind-Up

From this short tutorial, we have described the simple formula used to calculate Two-Way Summary with SUMIFS. Please share your query below in the comment box. We will assist you. Click here to know more about Geek Excel *and Excel Formulas *!!

Read Next:

• Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!
• Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!
• Formulas to Create a Two-way summary Count with COUNTIFS!!
• Excel Formulas to Find the Two-Way Approximate Match Lookup!!
• Formulas to Calculate the Sum of the Time with SUMIFS Function!!