How to Use SUMX2PY2 Function

The SUMX2PY2 function returns the sum of the number's square in two arrays.


= SUMX2PY2(array_x, array_y)


- Array_x is required, which is the first array.

- Array_y is required, which is the second array.


– Array_x and array_y will have the same number of values, otherwise, returns #N/A error.

Example: What is the sum of the square of Array A and B?


The result returns to 490.

Download: SUMX2PY2 Function

Leave a Reply