Formulas to Create a 3D Sum with Multiple Worksheets in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-20 12:05:47

---
title: Formulas to Create a 3D Sum with Multiple Worksheets in Excel!!
published: true
date: 2020-11-20 11:59:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-create-a-3d-sum-with-multiple-worksheets/
---

Here, we will discuss the **formulas to create a 3D sum with multiple worksheets in Excel Office 365**. Let’s see them below!!  
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)

[![Formulas to create 3D sum with multiple worksheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-create-3D-sum-with-multiple-worksheets.png)](https://geekexcel.com/excel-formulas-to-create-a-3d-sum-with-multiple-worksheets/formulas-to-create-3d-sum-with-multiple-worksheets/#main)<figcaption id="caption-attachment-17734">Formulas to create 3D sum with multiple worksheets</figcaption>
## General Formula:

- To sum the same range in one or more sheets in Excel, use the below formula.

**=[SUM](https://geekexcel.com/sum-function/)([Sheet1](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/):Sheet3! A1)**

## Syntax Explanations:

- **SUM** – In Excel, this function adds values from the cells. Read more on the **[SUM Function](https://geekexcel.com/sum-function/)**.
- **Sheet** – The **[Sheet Function](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/)** will return the index number of the sheet.
- **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 (A1)** – 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 in Excel.
- Refer to the below image.
- It shows the input ranges of multiple worksheets.

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

- In the below image, we will enter the given formula in **Cell C3**.
- 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-51.png)<figcaption id="caption-attachment-17731">Example</figcaption>

## Bottom-Line:

From this tutorial, we described the **formulas used to create a 3d sum with multiple worksheets in Excel Office 365**. Hope that this article is useful to you. If you have any **queries/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 Also:

- **[Formulas to Count Rows that meet OR Logic in Excel Office 365!!](https://geekexcel.com/formulas-to-count-rows-that-meet-or-logic-in-excel-office-365/)**
- **[Excel Formulas To Count Unique Values In a Column!!](https://geekexcel.com/excel-formulas-to-count-unique-values-in-a-column/)**
- **[Excel Formulas to Count Cells that contain either X or Y!!](https://geekexcel.com/excel-formulas-to-count-cells-that-contain-either-x-or-y/)**
- [**Formulas to Count the Rows that contain at least N Matching Values!!**](https://geekexcel.com/formulas-to-count-the-rows-that-contain-at-least-n-matching-values/)