10 *next level* SUMIFS tricks only Excel Pros KNOW скачать в хорошем качестве

10 *next level* SUMIFS tricks only Excel Pros KNOW

Take your SUMIFS & other ifs skills to next level with these 10 powerful techniques. Sample file: ========= https://chandoo.org/wp/wp-content/upl... Topics covered in this video (timestamps): ================================== 0:00 - Introduction 0:26 - 2D SUMIFS 1:04 - SUMIFS with multiple AND conditions 1:39 - SUMIFS with OR condition 2:46 - SUMPRODUCT alternative 3:32 - Multi-condition lookup with SUMIFS 4:10 - Greater than, less than conditions 4:31 - SUM between dates 5:29 - Pattern matching (wildcards) with formulas 6:00 - More pattern matching 6:41 - MEDIANIFS, MAXIFS, MINIFS 8:06 - UNIQUE Count with COUNTIFS and new formulas Resources to learn more on SUMPRODUCT =================================== Introduction and basic usage - https://chandoo.org/wp/excel-sumprodu... Advanced examples - https://chandoo.org/wp/advanced-sumpr... Watch these next ============== Dynamic Array formulas -    • Learn about the *NEW* Dynamic Array F...   Longer video (live stream) -    • Beginner to Pro ~ Excel Dynamic Array...   #advancedExcel