Download the featured file here: [ Ссылка ]

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

свернуть