SUMX2MY2

Calculates the sum of the differences of the squares of values in two arrays.

Sample Usage

SUMX2MY2({1,2,3},{4,5,6})

SUMX2MY2(A2:A9,B2:B9)

Syntax

SUMX2MY2(array_x, array_y)

  • array_x - The array or range of values whose squares will be reduced by the squares of corresponding entries in array_y and added together.

  • array_y - The array or range of values whose squares will be subtracted from the squares of corresponding entries in array_x and added together.

See Also

SUMXMY2: Calculates the sum of the squares of differences of values in two arrays.

SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.

Examples

Was this article helpful?
How can we improve it?