Back to lesson
1. What is the main difference between the comma notation form of SUMPRODUCT (=SUMPRODUCT(Argument1, Argument2) and the multiplication notation form of SUMPRODUCT (=SUMPRODUCT(Argument1 * Argument2)?
The comma notation only allows cross-multiplication between ranges containing only one row or only one column, whereas the multiplication form allows a form of matrix algebra
There is no difference
The comma notation sums elements of ranges, whereas the multiplication notation multiplies these same elements
2. How does SUMPRODUCT treat non-numerical entries?
All non-numerical values are treated as zeros except errors
Since text multiplied by a number gives #VALUE!, SUMPRODUCT gives this same error
All non-numerical values are treated as zeros
3. Which of the following formulae would calculate the weighted average of the data correctly?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement