# Documentation/How Tos/Calc: SUMXMY2 function

From Apache OpenOffice Wiki

< Documentation | How Tos

CALC FUNCTIONS

## Contents

## SUMXMY2

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

### Syntax:

**SUMXMY2(x; y)**

*Advanced topic:*

evaluates its parameters**SUMXMY2**and**x**as array formulas but does not need to be entered as an array formula. In other words it can be entered with the**y****Enter**key, rather than**Cntrl-Shift-Enter**. See the example below.

### Example:

**SUMXMY2(A1:A2; {2|1})**

- where cells A1 and A2 contain
and**4**respectively, returns (4-2)**3**^{2}+ (3-1)^{2}=.**8**

*Advanced topic (parameter evaluated as array formula):*

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

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

**See Also**