How to Use the SUMPRODUCT Function and Formula in Excel In this tutorial, you’ll learn how to use the SUMPRODUCT function and formula in Excel.  SUMPRODUCT multiplies arrays or ranges and returns the sum of products. SUMPRODUCT Syntax The syntax of the SUMPRODUCT() function is as follows: =SUMPRODUCT(array1, [array2], [array3],…) For example: =SUMPRODUCT({1,2,3}, {10,20,30}) =SUMPRODUCT(A1:B4, D2:E4) Return value … Continue reading Excel SUMPRODUCT Function and Formula with Examples