SUMX2PY2 function
Summary
Returns the sum of the sum of squares of corresponding values in two arrays
Syntax
SUMX2PY2(array_x, array_y)
The SUMX2PY2 function syntax has the following arguments:
• Array_x Required. The first array or range of values.
• Array_y Required. The second array or range of values.
• Array_x Required. The first array or range of values.
• Array_y Required. The second array or range of values.
Example
=SUMX2PY2(A3:A9,B3:B9)
=SUMX2PY2({2,3,9,1,8,7,5}, {6,5,11,7,5,4,4})
=SUMX2PY2({2,3,9,1,8,7,5}, {6,5,11,7,5,4,4})