Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| (3 intermediate revisions by 2 users not shown) | |||
| 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). | ||
| Line 64: | Line 62: | ||
=SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as <br />((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). Returns '''-91''' as a result. | =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as <br />((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 <br />((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). Returns '''-756''' as a result. | =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as <br />((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 '''- | + | =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-9''' as a result. |
==Related Videos== | ==Related Videos== | ||
| Line 79: | Line 77: | ||
*[http://en.wikipedia.org/wiki/Product_(mathematics) Product] | *[http://en.wikipedia.org/wiki/Product_(mathematics) Product] | ||
*[http://en.wikipedia.org/wiki/Summation Summation] | *[http://en.wikipedia.org/wiki/Summation Summation] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:47, 21 August 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