Back to lesson
1. In the illustration, which formula typed into cell C17 would derive the same result as that already calculated in cell D15?
2. In this example, the formula =SUMPRODUCT((B5:B16=J4)*(C5:C16=J5)*(D5:D16=J6)*(E5:E16=J7)*F5:F16) has been used to show an alternative to using the SUMIFS function. Which of the following is the primary reason the various arguments multiplied (e.g. (B5:B16=J4)) are delineated using brackets?
The SUMPRODUCT syntax requires all ranges to be included in brackets.
It makes the formula easier to read
This is because otherwise multiplication will be performed by Excel before the equality checks (i.e. it is to ensure the correct calculation order)
3. Which of the following statements is true concerning the SUMPRODUCT function?
SUMPRODUCT enables the user to avoid using complicated formulae by summing up the products of individual corresponding cells referenced vectors or arrays with shared dimensions.
SUMPRODUCT works with array arguments of different dimensions
The SUMPRODUCT function will not work with entries that are not numeric
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement