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:
=========

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
===================================

Watch these next
==============

#advancedExcel