SUMXMY2

Calculates the sum of the squares of differences of values in two arrays.

Sample Usage

SUMXMY2({1,2,3},{4,5,6})

SUMXMY2(A2:A9,B2:B9)

Syntax

SUMXMY2(array_x, array_y)

  • array_x - The array or range of values that will be reduced by corresponding entries in array_y, squared, and added together.

  • array_y - The array or range of values that will be subtracted from corresponding entries in array_x, the result squared, and all such results added together.

See Also

SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.

SUMX2MY2: Calculates the sum of the differences of the squares of values in two arrays.

Examples

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false