Using SUMIFS with arrays | Excel problem... Solved! | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ https://exceloffthegrid.com/sumifs-with-arrays/ ★ About this video ★ Have you ever put a dynamic array formula inside SUMIFS... of course you have. Or else why would you be here? Well, let's solve this problem... how can we use SUMIFS with arrays??? 0:00 Introduction 0:32 The problem 4:01 Using range functions 6:35 FILTER/SUM 8:10 SUMIFS Spill Range 10:45 GROUPBY 12:51 Conclusion The video for how to Stack multiple filters is here: https://www.youtube.com/watch?v=AgAVMTbNDYs ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel