Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 65: | Line 65: | ||
=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 '''-3''' as a result. | =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-3''' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | {{#ev:youtube|rwsX1KVhEnU|280|center|SUMPRODUCT}} | ||
==See Also== | ==See Also== | ||
Revision as of 13:15, 16 April 2015
SUMPRODUCT(arr1, arr2, .....)
- where are arrays whose values are to be multiplied and then added.
are arrays whose values are to be multiplied and then added.SUMPRODUCT() multiplies the corresponding array values and displays their sum as a result.
Description
SUMPRODUCT(arr1, arr2, .....)
- 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.
- 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 -3 as a result.