SUMXMY2 function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Returns the sum of squares of differences of corresponding values in two arrays

Syntax

SUMXMY2(array_x, array_y) The SUMXMY2 function syntax has the following arguments:
• Array_x The first array or range of values. Required.
• Array_y The second array or range of values. Required.

Example

=SUMXMY2(A3:A9,B3:B9)
=SUMXMY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})

Microsoft Support Page

https://support.microsoft.com/en-us/office/sumxmy2-function-9d144ac1-4d79-43de-b524-e2ecee23b299

Back to Functions