SUMX2MY2 function

From Apache OpenOffice Wiki
Jump to: navigation, search


Returns the sum of the differences between corresponding squared elements of two matrices.


SUMX2MY2(x; y)

x and y are arrays or ranges of the same size. SUMX2MY2 calculates Calc sumx2my2 equation.png for the i elements in the arrays.
Advanced topic:
SUMX2MY2 evaluates its parameters x and y as array formulas but does not need to be entered as an array formula. In other words, it can be entered with the  ↵ Enter  key, rather than  Cntrl  +  ⇧ Shift  +  ↵ Enter . See the example below.


SUMX2MY2(A1:A2; {2|1})

where cells A1 and A2 contain 4 and 3 respectively, returns (42-22) + (32-12) = 20.

Advanced topic:

SUMX2MY2(A1:A2+1; {2|1})

when entered 'normally' (not as an array formula), and where cells A1 and A2 contain 3 and 2 respectively, returns ((3+1)2-22) + ((2+1)2-12) = 20. SUMX2MY2 forces (A1:A2+1) to be evaluated as an array formula (internally returning the array {4|3}).

See Also
Personal tools