SUMX2PY2

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

Sample Usage

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

SUMX2PY2(A2:A9,B2:B9)

Syntax

SUMX2PY2(array_x, array_y)

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

  • array_y - The array or range of values whose squares will be added to 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.

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

Examples

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
13790946426980854112
true
Search Help Center
true
true
true
true
true
35
false
false