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:

Argument Description
array_x The first range of cells.
array_y The 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