Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =SUMPRODUCT( | + | <div style="font-size:30px">'''SUMPRODUCT()'''</div><br/> |
| + | *Parameters are arrays whose values are to be multiplied and then added. | ||
| − | + | SUMPRODUCT(), returns the sum of the products of corresponding array components. | |
| − | |||
| − | SUMPRODUCT() | ||
== Description == | == Description == | ||
| − | SUMPRODUCT( | + | SUMPRODUCT() |
*This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result. | *This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result. | ||
| − | *Argument | + | *Argument are the numbers to be multiplied and then added. |
| − | * | + | *Parameters should be of same dimensions, else Calci displays #N/A error message. |
*Non-numeric values are considered zero (0). | *Non-numeric values are considered zero (0). | ||
Revision as of 15:58, 3 July 2018
SUMPRODUCT()
- Parameters are arrays whose values are to be multiplied and then added.
SUMPRODUCT(), returns the sum of the products of corresponding array components.
Description
SUMPRODUCT()
- This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result.
- Argument are the numbers to be multiplied and then added.
- Parameters should be of same dimensions, else Calci displays #N/A error message.
- Non-numeric values are considered zero (0).
Examples
| Array 1 | Array 1 | Array 2 | Array 2 | Array 3 | Array 3 |
| 1 | 4 | 7 | 7 | -1 | -4 |
| 2 | 5 | 8 | 8 | -2 | -5 |
| 3 | 6 | 9 | 9 | -3 | -6 |
=SUMPRODUCT(A2:B4,C2:D4) : Calculates SUMPRODUCT of Array1 and Array2 as ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)).
Returns 172 as a result. =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as
((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). Returns -91 as a result. =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as
((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). Returns -756 as a result. =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns -9 as a result.
Related Videos
See Also
References