Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/10/SUMIF-Across-Worksheets.xlsx

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