Question: what is the difference between sum and sumproduct in excel?
Answer: The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility. ... array2 - [optional] The second array or range to multiply, then add.