Excel Formulas: 3D SUMIF for Multiple Worksheets!!
Tags: excelformula, excelformulas
Published: 2020-11-21 08:01:14

---
title: Excel Formulas: 3D SUMIF for Multiple Worksheets!!
published: true
date: 2020-11-21 07:59:55 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-3d-sumif-for-multiple-worksheets/
---

This page will show the simple **formulas to 3D sum the identical ranges for multiple worksheets using the SUMIF function in Excel**. 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)
## General Formula:

- The below formula will help to sum the same range in one or more sheets using the SUMIF Function.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(SUMIF([INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(“‘”&[sheets](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/)&”‘!”&”range”),criteria,INDIRECT(“‘”&sheets&”‘!”&”sum range”)))**

## Syntax Explanations:

- **SUMPRODUCT** – This function will help to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the**[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) Function**.
- **SUMIF** – It will return the sum of cells that meet a single condition. Read more on the **SUMIF Function**.
- **INDIRECT** – In Excel, the **[INDIRECT Function](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)** helps to return a valid reference from a given text string.
- **SHEETS** – The **Sheets function** returns the number of sheets in a given reference.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input range from your workbook.
- **Criteria**  – It is the condition that is used to count the values.

## Example:

- Now, we will see how to sum the same range in one or more sheets using the **SUMIF function**.
- Refer to the below image.
- It shows the input ranges of multiple worksheets.
- From the input range, we are going to find the **sum of the project hours** in the individual worksheets.

![Example Data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/collage-1.jpg)<figcaption id="caption-attachment-17779">Example Data</figcaption>

- Let’s see the below image, to sum the values.
- First, we will enter the sheet names in **Column B** and define the name as Sheets.
- Then, enter the given formula in the formula bar section.
- Finally, it will sum the same range from the above three sheets and display the result as shown in the below image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-52.png)<figcaption id="caption-attachment-17780">Example</figcaption>

## Bottom-Line:

From this tutorial, we explained the **formulas to 3D sum the identical ranges for multiple worksheets using the SUMIF function in Excel Office 365**. If you have any doubts, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!](https://geekexcel.com/formulas-for-counting-unique-values-in-a-range-with-countif-in-excel/)**
- **[Excel Formulas to Count Numbers by Range with COUNTIFS Function!!](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)**
- [**Formulas to Count with COUNTIF Function in Excel Office 365!!**](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)