SUMXMY2
Returns the sum of squares of differences of corresponding values in two arrays
Syntax
SUMXMY2(array_x, array_y)
Parameters
- array_x: Required. The first array or range of values
- array_y: Required. The second array or range of values
Example
=SUMXMY2(A1:A5, B1:B5)