SUMX2MY2

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

Sample Usage

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

SUMX2MY2(A2:A9,B2:B9)

Syntax

SUMX2MY2(array_x, array_y)

  • array_x - The array or range of values whose squares will be reduced by the squares of corresponding entries in array_y and added together.

  • array_y - The array or range of values whose squares will be subtracted from the squares of corresponding entries in array_x and added together.

See Also

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

SUMX2PY2: Calculates the sum of the sums 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