Documentation/How Tos/Calc: SUMXMY2 function
From Apache OpenOffice Wiki
SUMXMY2
Returns the sum of the squared differences between corresponding elements of two matrices.
Syntax:
SUMXMY2(x; y)
- x and y are arrays or ranges of the same size. SUMXMY2 calculates for the i elements in the arrays. It evaluates in array mode, but does not need to be entered as an array formula.
Example:
SUMXMY2(A1:A2; {2|1})
- where cells A1 and A2 contain 4 and 3 respectively, returns (4-2)2 + (3-1)2 = 8.
See also:
SUM, SUMIF, SUMSQ, SUMPRODUCT,SUMX2MY2, SUMX2PY2