Today I will show you how to sum values across multiple Worksheets based on a condition.

💻 Download the practice file
=========================
[ Ссылка ]

I have sales data for January, February, and March. And I want to get the total revenue for all Products across all those Worksheets. Using the VSTACK function, you can easily combine ranges. Type the function and add the first argument. Select the first sheet you want to include in the v-stack.
Press and hold shift then select the Worksheets. Select the Products column from B3 to B13. Press enter to return all Products across all sheets. Repeat these steps for the Revenue column to list all data from multiple sheets.

The next step is to apply these formulas within the filter function. Type FILTER and add the first argument, the array containing Revenues. The second argument is include. Now, you can set the criteria. I want to summarize Revenues for "Apple" in this cell, so add the B3 cell as a criteria.
Press Enter. Now we have the revenue from all Worksheets.
Finally, use SUM. Okay, copy the formula to get the total revenue for all Products across all of those sheets.

00:00 Intro
00:10 How to SUM Across Multiple Worksheets with Criteria in Excel

#exceltips #exceltutorial #excel #msexcel

свернуть