Calculates the sum of the differences of the squares of values in two arrays or ranges.

**Sample Usage**

SUMX2MY2({2, 3, 11, 7}, {6, 5, 9, 1})

SUMX2MY2(A2:A9,B2:B9)

**Syntax**

SUMX2MY2(array1, array2)

- array1 - The first array or range to consider while calculating the sum of the difference of squares.

- array2 - The second array or range to consider while calculating the sum of the difference of squares.

**Examples**

SUMXMY2({2, 3, 11, 7}, {6, 5, 9, 1}) returns the sum of squares of differences of the two arrays constants - this case 40 .

SUMX2MY2(A2:A9,B2:B9) returns the sum of squares of differences of the two arrays constants - A2:A9 and B2:B9.