Spread Formula Reference
SUMX2MY2
Formula Functions > Functions R to S > SUMX2MY2

This function returns the sum of the difference of the squares of corresponding values in two arrays.

Syntax

SUMX2MY2(array_x,array_y)

Arguments

This function has these arguments:

Argument Description
array_x First array of values (x’s)
array_y Second array of values (y’s)

The arrays must be the same size.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SUMX2MY2(A1:A17,B1:B17)

Version Available

This function is available in product version 1.0 or later.

See Also

SUMX2PY2 | SUMXMY2 | SUM | Math and Trigonometry Functions