How to use SUMIF across multiple sheets in Excel?

How to use SUMIF across multiple sheets in Excel? Tutorial showing how to make a SUMIF function work with many sheets in Microsoft Excel. This Excel Tutorial uses SUMIF along with INDIRECT and SUMPRODUCT letting you use SUMIF with more than one worksheet.
Want to follow along? Exercise files can be found here:
https://www.computertutoring.co.uk/ex...
The above link also contains step-by-step instructions and a further explanation of how the SUMIF with multiple sheets function works.

Chapters
00:00 Start and the problem with basic SUMIF
01:30 Get straight to the SUMIF multiple sheets formula
04:26 Use INDIRECT to reference a cell sheet in SUM function
07:15 SUMPRODUCT & SUMIF & INDIRECT - How do they work together?
11:47 Adjust the dollar signs in the formula enabling autofill

Want to learn more? Check out our Excel 365 Advanced Course in London.
https://www.computertutoring.co.uk/mi...

😊 Check out my website and social media too keep up to date - enjoy learning 😊

📱 http://www.computertutoring.co.uk/ 📱

📽 TikTok: thecomptutor 📽

👨‍👩‍👧‍👦  Facebook: ComputerTutoring.co.uk 👨‍👩‍👧‍👦

🦉 Twitter: CT_Tutoring 🦉

 📷Instagram: computer_tutoring 📷

 📌https://www.pinterest.co.uk/CT_Training/ 📌

• #education
• #how_to_use_sumif_across_multiple_sheets_in_excel
• #sumif_excel
• #sum_if_excel
• #sumif_multiple_sheets
• #sum_if_multiple_sheets
• #sumif_across_many_sheets
• #how_to_use_sum_if_with_many_sheets
• #xl_tutorial
• #excel_tips
• #excel_tricks
• #sumin_with_a_lot_of_sheets
• #using_sumif_across_sheets
• #sum_if_across_all_the_sheets
• #how_to_sum_across_multiple_sheets
• #sum_if_when_theres_many_sheets
• #how_do_i_do_sumif_across_many_sheets
• #using_sum_with_if_across_multiple_sheets
• #multiple_sheets_sumif