Learn Excel Episode 662: SumProduct
There. I said it. SumProduct. Some of my friends in the U.K. seminars asked why I NEVER talk about SumProduct. And there is a really simple, but really stupid reason for it…. I missed that day in Excel class. SumProduct simply was not in my arsenal of tools, and so I find myself writing complex array formulas when a SumProduct would do the trick. In today’s Episode 662, we take a look at how to convert yesterday’s array formulas to SUMPRODUCT formulas.