Excel’s SUMPROD function is an incredibly useful tool for performing complex calculations that go outside simple addition. It allows you to boost corresponding components in one or more arrays, and then sum the products – all in a sumproduct si… Read More