SUMX2MY2 function
Summary
Returns the sum of the difference of squares of corresponding values in two arrays
Syntax
SUMX2MY2(array_x, array_y)
The SUMX2MY2 function syntax has the following arguments:
• array_x Required. The first array or range of values.
• array_y Required. The second array or range of values.
• array_x Required. The first array or range of values.
• array_y Required. The second array or range of values.
Example
=SUMX2MY2(A2:A8,B2:B8)
=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})
=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})