SUMX2MY2

Syntax:

SUMX2MY2 ( array-1 , array-2 )

Description: Computes the sum of the difference of squares of the corresponding numerical elements in two arrays designated by array-1 and array-2.

Mathematical Formula:

where array-1 contains the x values, and array-2 contains the y values.

Arguments:

Name

Type

Description

array-1

array, reference

Designated the arrays to be operated on. If an argument contains text, logical values, or empty cells, those elements shall be ignored; however, cells with the value 0 shall be included.

array-2

Return Type and Value: number – The sum of the difference of squares of the corresponding elements in two arrays designated by array-1 and array-2.

However, if array-1 and array-2 have a different number of values, the return value is unspecified.

example: