Formulas and Functions

SUMX2MY2
The SUMX2MY2 function returns the sum of the dierence of the squares of
corresponding values in two collections.
SUMX2MY2(set-1-values, set-2-values)
 set-1-values: The rst 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 dierences of the squares of the values in
column A and the squares of the values in column B. The formula for the rst such dierence 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