SUMPRODUCT WITH IF CRITERIA/CONDITIONS - COUNT and SUM ARRAYS Examples

This video explains how to use Excel's SUMPRODUCT function to count and sum values based on a condition/criteria. The examples explain how to do the calculations using helper columns and without SUMPRODUCT but then shows you how SUMPRODUCT is a lot more efficient and space saving way to go.