SUMXMY2 Function

The SUMXMY2 function finds the sum of the squares of the differences of the corresponding values in the given 2 arrays.

Formula:


=SUMXMY2(Array1, Array2)
Whereas "Array1" is the first range of values and "Array2" is the second range of values.

Video Tutorial:


Let us find the sum of the sum of the squares, using the SUMXMY2 function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question