SUM Across Multiple Sheets with Criteria | How to SUMIF Multiple Sheets in Excel | 3D SUMIF

Download the featured file here: www.bluepecantraining.com/wp-...
In this comprehensive Excel tutorial, you'll learn how to SUM values across multiple sheets with specific criteria. Whether you're using an older version of Excel or the latest Excel 365, I've got you covered with two different methods!
🔥00:00 Introduction
🔥00:19 Method 1( works with all versions of Excel)
🔥00:35 How Excel references cells on another worksheet
🔥01:24 The INDIRECT function - how it works and why it helps
🔥03:26 Use SUMIF with INDIRECT
🔥04:24 Use SUMPRODUCT with SUMIF and INDIRECT
🔥05:07 Method 2 (Excel 365 users only)
🔥05:17 Use VSTACK to combine the sheet's data
🔥05:54 Use SUM and FILTER instead of SUMIF to sum based on criteria
🔥07:15 Use the LET function to tidy up the formula
Whether you're a beginner or an Excel pro, this tutorial will equip you with the knowledge to efficiently SUM data across multiple sheets, making your Excel tasks a breeze. Don't forget to like, share, and subscribe for more Excel tips and tricks!
#exceltutorial #exceltips #excel365 #excel

[@baarg8672]

you are the best!! literally ive seatched all the internet (bing) and only here ive found multiple solutions even for 365 version, kudos! and be safe! let, vstack and filters is what i needed)

[@nataliewinn1695]

Amazing!!!🎉

[@swathirufina]

life saver. thank you

[@user-jp5eo5qy5l]

thank you !

[@edenworkaferahu9755]

This saved my life!!!!!!!! Thank youuuuuuuu

[@andreasrom6812]

The VStack solution help me alot, thanks! :-)

[@PeanutandChiquis]

How do we add using SUMIFS with multiple criteria? I dont have Excel 365, your formula worked for a single criteria but I got stuck with those that have more than one criteria please help thanks!

[@ezbrown]

This is great! Is it possible to use the vstack across a number of different workbooks with the same structure rather than sheets in one workbook?

[@baarg8672]

cant make programmable sumif range with indirect function: two cells representing start sheet and end sheet but it counts only that two sheets but not all inbetweens

[@monicasalvarez]

This worked for my row one. But going down it (I typed each formula separately, did not copy down) only pulls from one sheet even tho I select multiple sheets.

[@miracleboi7336]

does this work when I'm working on only 2 sheets? 1 is for the data and the other one is the summary sheet.

[@cnix217]

This only works with number format and not general and it still adds values if the include cell is blank. Anyone figure out how to fix these?