Summary
Keywords
Full Transcript
Take your SUMIFS & other ifs skills to next level with these 10 powerful techniques. Sample file: ========= https://chandoo.org/wp/wp-content/uploads/2021/05/sumifs-xifs-examples-demo.xlsx 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-sumproduct-formula/ Advanced examples - https://chandoo.org/wp/advanced-sumproduct-queries/ Watch these next ============== Dynamic Array formulas - https://youtu.be/ONaS7IMKJPM Longer video (live stream) - https://youtu.be/8IV_W13VFkw #advancedExcel
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
