Excel SUMPRODUCT Function
The Excel SUMPRODUCT function is a little known function. However it has a very fitting name because it multiplies and then returns the sum of the groups of multiplications, or creates a SUM of the PRODUCT. Starting With The SUMPRODUCT Function SUMPRODUCT(array1, [array2], [array3], …) array1 = the first array that you […]