Parameter List
Syntax
SUMX2MY2(array_x, array_y)
array_x
The first array or range of values to square. For example: A1:A3
.
array_y
The second array or range of values to square and subtract. Must be the same size as array_x
. For example: B1:B3
.
More details
SUMX2MY2 computes the sum of the difference between the squares of values in two arrays: ∑(x² - y²). Each element in array_x
is squared and then reduced by the square of the corresponding element in array_y
. Both arrays must have the same length; otherwise the function returns an error.