SUMX2PY2

Definition: The SUMX2PY2 function in Excel is used to find the sum of the sum of squares of two corresponding arrays.

Syntax: ==SUMX2PY2(array_x, array_y).

Situation: This formula is appropriate in situations where you need to find the sum of the sum of squares of two corresponding arrays.

Example: If you have two arrays A1:A5 and B1:B5 that contain the numbers 1, 2, 3, 4, and 5, you would use the formula =SUMX2PY2(A1:A5, B1:B5). This would return a value of 110, which is the sum of the sum of squares of the two arrays.