SUMX2MY2

Calculates the sum of squared values in the first array minus squared values in the second array, element by element. Arrays must be the same size.

Parameter List

Syntax
SUMX2MY2(array_xarray_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.

Examples

SUMX2MY2(A1:A2, B1:B2) returns 20