SUMXMY2

  • Updated

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

Sample Usage

SUMXMY2({2,3,9,1,8,7,5}, {6,5,11,7,5,4,4})
SUMXMY2(A2:A9,B2:B9)

Syntax

SUMXMY2(array1, array2)

  • array1 - The first array or range to consider while calculating the sum of squares of differences of values.
  • array2 - The second array or range to consider while calculating the sum of squares of differences of values.

Examples

SUMXMY2({2,3,11,7}{6,5,9,1}) returns the sum of squares of differences of the two arrays constants - in this case: 60.
SUMXMY2(A2:A9,B2:B9) returns the sum of squares of differences of the two arrays constants - A2:A9 and B2:B9.