Calculates the sum of the sums of the squares of values in two arrays.

How To Use in Sheets

SUMX2PY2(array_x, array_y)

External Links

Excel SUMX2PY2 Function - How to use SUMX2PY2 Function

The Microsoft Excel SUMX2PY2 function calculates the sum of the squares of corresponding items in the arrays and returns the sum of the results.

0Better Sheets Tutorials

No videos yet. Stay tuned!