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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999