SUMX2MY2 Function in Google Sheets

Calculate the sum of the squares of the differences between corresponding values in two arrays using the SUMX2MY2 function.

SUMX2MY2 Function

The SUMX2MY2 function in Google Sheets calculates the sum of the squares of the differences between corresponding values in two arrays.

Syntax

SUMX2MY2(array_x, array_y)
  • array_x: The first array or range of values.
  • array_y: The second array or range of values.

Examples

  1. Basic Example

Calculate the sum of the squares of the differences between arrays in A1:A5 and B1:B5:

=SUMX2MY2(A1:A5, B1:B5)
  1. Example with Different Ranges

Using the function with arrays in C1:C5 and D1:D5:

=SUMX2MY2(C1:C5, D1:D5)

Notes

  • The function requires both arrays to be of the same size.
  • SUMX2PY2: Calculate the sum of the squares of the sums of corresponding values.
  • SUMXMY2: Calculate the sum of the squares of the differences between corresponding values in two arrays.