next up previous contents index
Next: SYD Up: A. Function Reference Previous: SUM   Contents   Index


SUMPRODUCT

Syntax: SUMPRODUCT(R1, R2)

R1 = a vector
R2 = a vector

SUMPRODUCT returns the sum of products of two vectors. R1 must have the same number of rows and columns as R2, or R1 and R2 can be one-dimensional vectors of the same length.

Examples:

Matrix 1, D4..E5 =

  D E
4 2 3
5 4 6
     

Matrix 2, D7..E8 =

  D E
7 -5 0
8 2 8
     

SUMPRODUCT(D4..E5, D7..E8) = 46

SUMPRODUCT(D4..D5, D7..E7) = -10

SUMPRODUCT(A1..A2, M1..P4) = Error - incompatible range dimensions

Excel function: SUMPRODUCT


next up previous contents index
Next: SYD Up: A. Function Reference Previous: SUM   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003