Excel 2016 – 3.10.5 – How Conditions Work

How can the SUMPRODUCT function multiply and sum, when the conditions being set are Text? This video explains how this very clever function works.