The Secret Power of SUMPRODUCT in Excel

SUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together.  However, SUMPRODUCT is a function that accepts arrays, making it a very powerful function beyond its basic use. In this video, you will learn the secret power of SUMPRODUCT as we work through 5 different examples Basic traditional use SUMPRODUCT […]