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

• #science_technology
• #chandoo
• #chandooorg
• #excel
• #spreadsheets
• #sumifs_excel
• #how_to_use_sumifs
• #sumif_function_in_excel
• #advanced_functions_excel
• #data_analysis_with_excel_examples
• #advanced_sumifs
• #advanced_excel_topics
• #best_excel_formulas_to_know
• #sum_values_between_two_dates_excel
• #sum_values_between_two_numbers_in_excel
• #conditional_median_formula_excel
• #medianif
• #medianifs
• #unique_count_in_excel
• #distinct_count_in_excel