# 3D SUMIF for Multiple Worksheets

Excel is a powerful tool that can help you manage and analyze data in a variety of ways. One of the most useful features of Excel is the SUMIF function, which allows you to sum values in a range based on a specific condition. However, what if you need to sum values across multiple worksheets? In this article, we will explore how to use the 3D SUMIF function to sum values across multiple worksheets in Excel.

## What is 3D SUMIF?

The 3D SUMIF function is a variation of the SUMIF function that allows you to sum values across multiple worksheets in a workbook. It works by specifying the range of worksheets that you want to include in the calculation, along with the range of cells that you want to sum and the condition that you want to apply.

## How to Use 3D SUMIF

Using the 3D SUMIF function is relatively straightforward. Here are the steps:

### Step 1: Select the Cell Where You Want to Display the Result

The first step is to select the cell where you want to display the result of the 3D SUMIF function.

### Step 2: Enter the 3D SUMIF Function

Next, enter the 3D SUMIF function in the selected cell. The syntax of the 3D SUMIF function is as follows:

=SUMIF(range, criteria, sum_range)

Where:

• range is the range of worksheets that you want to include in the calculation. You can specify the range using the following syntax:

‘Sheet1:Sheet3’!A1:A10

This specifies that you want to include worksheets Sheet1, Sheet2, and Sheet3, and the range of cells A1:A10 in each worksheet.

• criteria is the condition that you want to apply. This can be a number, text, or logical expression.
• sum_range is the range of cells that you want to sum across the specified worksheets.

### Step 3: Press Enter

Once you have entered the 3D SUMIF function, press Enter to calculate the result.

## Example

Let’s say you have a workbook with three worksheets: Sales, Expenses, and Profit. Each worksheet contains a table with the following columns: Date, Product, and Amount. You want to calculate the total sales for a specific product across all three worksheets. Here’s how you can do it:

### Step 1: Select the Cell Where You Want to Display the Result

Select the cell where you want to display the result of the 3D SUMIF function. Let’s say you want to display the result in cell A1 of a new worksheet called Summary.

### Step 2: Enter the 3D SUMIF Function

Enter the following 3D SUMIF function in cell A1 of the Summary worksheet:

=SUMIF(‘Sales:Profit’!B:B, “Product A”, ‘Sales:Profit’!C:C)

This function sums the values in column C of the Sales, Expenses, and Profit worksheets, where the value in column B is “Product A”.

### Step 3: Press Enter

Press Enter to calculate the result. The total sales for Product A across all three worksheets will be displayed in cell A1 of the Summary worksheet.

## Conclusion

The 3D SUMIF function is a powerful tool that can help you sum values across multiple worksheets in Excel. By specifying the range of worksheets, the condition, and the range of cells to sum, you can quickly and easily calculate complex totals and summaries. With this knowledge, you can take your Excel skills to the next level and become a more efficient and effective data analyst.

## Related

### All You Need to Know About Capital Bank Account

We discussed about the registered capital contribution requirement under the New Company Law in our previous article. We got some inquiries asking for advice about

### It’s Time to Plan Your Tax Break: How to handle the “6-year rule”

The Individual Income Tax Law (“the IIT Law”) which took effect on 1st January 2019 introduced the “6-year-rule” to determine the tax residency status of

## Share it with your friends or colleagues

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications

Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.