Parameter List
Syntax
SUMXMY2(array_x, array_y)
array_x
The first array or range of values. For example: A1:A3
.
array_y
The second array or range of values to subtract from array_x
. Must be the same size as array_x
. For example: B1:B3
.
More details
SUMXMY2 computes the sum of the squares of differences between two arrays: ∑(x − y)². Each difference (x − y) is squared and summed. Both arrays must have the same length; otherwise the function returns an error.