Article updated on March 13, 2018

The SUMXMY2 function calculates the sum of squares of differences of corresponding values in two arrays.

Formula in cell F3:

=SUMXMY2(B3:B5, D3:D5)

(4-2)^2 + (3-3)^2 + (4-4)^2 = 4

Excel Function Syntax

SUMX2MY2(array_x, array_y)


array_x Required. The first array or range of values.
array_y Required. The second array or range of values.