Skip to main content

SUMX2PY2 function

The SUMX2PY2 function is one of the math and trigonometry functions. It is used to sum the squares of numbers in the selected arrays and return the sum of the results.

Syntax​

SUMX2PY2(array_x, array_y)

The SUMX2PY2 function has the following arguments:

ArgumentDescription
array_xThe first range of cells.
array_yThe second range of cells with the same number of columns and rows as array_x contains.

Notes​

How to apply the SUMX2PY2 function.

Examples​

The figure below displays the result returned by the SUMX2PY2 function.

SUMX2PY2 Function