SUMPRODUCT practice
SUMPRODUCT multiplies matching values in two or more ranges and adds the results. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.
Syntax
SUMPRODUCT(array1, [array2], ...)
What people get wrong
Price times quantity for a whole order in one formula, and a weighted average when divided by the total weight.
financial modeling exercise that use SUMPRODUCT
- Terminal value by exit multipleLevel 4Pro
Practice SUMPRODUCT now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free