SumX2MY2

Syntax

SumX2MY2(X, Y)

Parameters

X. A cell range containing values of the first array.

Y. A cell range containing values of the second array.

NOTE. The dimensions of the first and the second array must match. Otherwise, the function returns 0.

Description

It returns the sum of differences of squares of corresponding values in two arrays.

Example

Formula Result Description
=SumX2MY2(B6:E6, B7:E7) 29,96 The sum of differences of squares for the specified values contained in the cell ranges between B6 and E6 and between B7 and E7. The B6:E6 range contains the following numbers: 3; 4; 3,6; -0,2; the B7:E7 range contains the following numbers: 2; -1,4; 0,8; 1,2.

See also:

Function Wizard │ Mathematical Functions │ Sum │ SumSq │ SumX2PY2 │ SumXMY2