EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1534-1535.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to create an Excel Spreadsheet Formula solution that calculates the Average Daily Revenue with the Average Function with SUMIFS inside. See a battle between the New Office 365 method using SEQUENCE Function or the old Excel way with the INDIRECT function.
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) https://www.youtube.com/watch?v=7jJMDGZpjSk