SUMXMY2

Calculates the sum of the squared differences between corresponding values in two arrays: ∑(x − y)². Arrays must be the same size.

Parameter List

Syntax
SUMXMY2(array_xarray_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.

Examples

SUMXMY2(A1:A2, B1:B2) returns 5