Apple iWork '09 - Manual (Page 202)

SUMX2MY2
The SUMX2MY2 function returns the sum of the difference of the squares of
corresponding values in two collections.
SUMX2MY2(set-1-values, set-2-values)
 set-1-values: The first collection of values. set-1-values is a collection containing
number values.
 set-2-values: The second collection of values. set-2-values is a collection containing
number values.
Example
Given the following table:
=SUMX2MY2(A1:A6,B1:B6) returns –158, the sum of the differences of the squares of the values in
column A and the squares of the values in column B. The formula for the first such difference is A1
2 –
B1 2 .
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
202 Chapter 8 Numeric Functions