Excel Function : SUMXMY2

Download now!

Excel Function : SUMXMY2

Category

Math and trigonometry

Description

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

Microsoft Excel Reference Page

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

Syntax and Description of the SUMXMY2 Excel Function

=SUMXMY2(array_x,array_y) This function returns the sum of the squares of the differences between corresponding values in two arrays.

About SUMXMY2 Excel Function

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