# SUMX2MY2

Formulas / SUMX2MY2
Calculate the sum of the squares of differences of corresponding values in two arrays.
`SUMX2MY2(array_x, array_y)`
• array_x - required, first set of numbers in a range or array
• array_y - required, second range of numbers

## Examples

• `=SUMX2MY2(A2:A8,B2:B8)`

The SUMX2MY2 function can be used to calculate the sum of the difference of squares of two arrays. For example, to calculate the sum of the difference of squares of two arrays A2:A8 and B2:B8, the formula used would be the same as above. This formula returns the sum of the difference of squares of the two arrays.

• `=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})`

The SUMX2MY2 function can also be used to calculate the sum of the squares of two constant arrays.This formula returns the sum of the squares of the two constant arrays.

## Summary

The SUMX2MY2 function calculates the sum of the difference of the squares of two arrays of numbers. It only accepts numeric values and ignores text, logical values, and empty cells.

• The SUMX2MY2 function returns the sum of the squares of the differences of corresponding values in two arrays.
• The arguments for SUMX2MY2 must be of the same size, and can be constants, cell references, or ranges.