Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 61: | Line 61: | ||
|} | |} | ||
| − | =SUMPRODUCT(A2:B4,C2:D4) : Calculates ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)). <br />Returns '''172''' as a result. | + | =SUMPRODUCT(A2:B4,C2:D4) : Calculates SUMPRODUCT of Array1 and Array2 as ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)). <br />Returns '''172''' as a result. |
| − | =SUMPRODUCT(A2:B4,E2:F4) : Calculates ((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). <br />Returns '''-91''' 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)). <br />Returns '''-91''' as a result. |
| − | =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates ((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). <br />Returns '''-756''' 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)). <br />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. | ||
Revision as of 16:25, 21 February 2014
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.