Function 10 – SUMPRODUCT
Complete Lessons and Earn Your Certificates Now
8. Most Used Functions
Microsoft Excel Basic Course
Back to Course
Back to Lesson
To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful SUMPRODUCT function.
Explanation: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500. The SUMPRODUCT function is an extremely versatile function and can produce the same result as many built-in functions in Excel and even array formulas