Excel Formulas to Calculate Two-way summary with SUMIFS!!
Tags: excelformula, excelformulas
Published: 2021-11-12 07:59:23

---
title: Excel Formulas to Calculate Two-way summary with SUMIFS!!
published: true
date: 2021-11-09 04:59:12 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/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](https://geekexcel.com/excel-formulas-lookup-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](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.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-65.png)
_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](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

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

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-formula-18.png)
_Use the Formula_

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

![](https://geekexcel.com/wp-content/uploads/2021/10/Output-49.png)
_Output_

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

![](https://geekexcel.com/wp-content/uploads/2021/10/Final-Output-3.png)
_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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!](https://geekexcel.com/excel-formulas-to-find-the-two-way-lookup-with-index-and-match/)**
- **[Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-find-two-way-lookup-with-vlookup/)**
- **[Formulas to Create a Two-way summary Count with COUNTIFS!!](https://geekexcel.com/excel-formulas-to-create-a-two-way-summary-count-with-countifs/)**
- **[Excel Formulas to Find the Two-Way Approximate Match Lookup!!](https://geekexcel.com/excel-formulas-find-two-way-approximate-match-lookup/)**
- **[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/)**