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-wi...

★ 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:    • How to Spill multiple FILTER function...  

★ 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:   / exceloffthegrid  

#MsExcel