FYI
Nice detailed explanation of SUMPRODUCT
A very good way to really understand how Excel evaluates a formula is to use the Evaluate Formula feature and step through the formula and see the results return in each argument of a function.
Ribbon Menu > Formulas > Evaluate Formula
Bookmarks