writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 62:
Line 62: − + − +
Manuals/calci/SUMPRODUCT (view source)
Revision as of 22:26, 21 February 2014
, 22:26, 21 February 2014no edit summary
=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,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 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,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 ((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 <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.