Formulas and Functions

Chapter 8 Numeric Functions 203
SUMX2PY2
The SUMX2PY2 function returns the sum of the squares of corresponding values in
two collections.
SUMX2PY2(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:
=SUMX2PY2(A1:A6,B1:B6) returns 640, the sum of the squares of the values in column A and the
squares of the values in column B. The formula for the rst such sum 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