SUMX2MY2 Function

The SUMX2MY2 function finds the sum of the difference of the squares of the corresponding values in the given 2 arrays.

Formula:


=SUMX2MY2(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 difference of the squares, using the SUMX2MY2 function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question