Skip to main content

SUMX2MY2 function

The SUMX2MY2 function is one of the math and trigonometry functions. It is used to sum the difference of squares between two arrays.

Syntax​

SUMX2MY2(array_x, array_y)

The SUMX2MY2 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 SUMX2MY2 function.

Examples​

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

SUMX2MY2 Function