Excel FunctionsLesson 113Free preview

SUMPRODUCT

This lesson is part of Excel · All levels

Summary

SUMPRODUCT multiplies the elements in a position of one or more arrays, and then sums the result. This function is often used to compute the conditional total and double count without the need for a special array of formulas. All the ranges you put in should be the same size.

Key points

So you dig up the elements in parallel and then you add up the multiplication.
All the argument ranges should be the same size
The logical conditions can be converted to 1 and 0 and then multiplied.
Can replace COUNTIFS and simple double calculations

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.