SUMX2PY2 Function in Google Sheets

Compute the sum of the squares of the sums of corresponding values in two arrays using the SUMX2PY2 function.

SUMX2PY2 Function

The SUMX2PY2 function in Google Sheets computes the sum of the squares of the sums of corresponding values in two arrays.

Syntax

SUMX2PY2(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 sums between arrays in A1:A5 and B1:B5:

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

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

=SUMX2PY2(C1:C5, D1:D5)

Notes

  • The arrays should be of the same length.
  • SUMX2MY2: Calculate the sum of the squares of the differences between corresponding values.
  • SUMXMY2: Calculate the sum of the squares of the differences between corresponding values in two arrays.