writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 65:
Line 65: + + +
no edit summary
=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==