theexcelclub.com
The Secret Power of SUMPRODUCT in Excel - The Excel Club
SUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together. However, being an array function it holds secret powers.