Article updated on March 13, 2018

The SUMX2MY2function calculates the sum of the difference of squares of corresponding values in two arrays.

Formula in cell F3:

=SUMX2MY2(B3:B5, D3:D5)

4^2 + 3^2 + 4^2 = 41

2^2 + 3^2 + 4^2 = 29

41 - 29 = 12

Excel Function Syntax

SUMX2MY2(array_x, array_y)

Arguments

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