Formulas and Functions

Chapter 8 Numeric Functions 201
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
SUMSQ
The SUMSQ function returns the sum of the squares of a collection of numbers.
SUMSQ(num-value, num-value…)
 num-value: A number. num-value is a number value.
 num-value…:Optionally include one or more additional numbers.
Usage Notes
The numbers can be in individual cells, or ranges of cells, or be included directly as Â
arguments to the function.
Examples
=SUMSQ(3, 4) returns 25.
=SUMSQ(A1:A4) adds the squares of the list of four numbers.
=SUMSQ(A1:D4) adds the squares of the 16 numbers in a square array of cells.
=SUMSQ(A1:A4, 100) adds the squares of the numbers in four cells plus 100.
=SQRT(SUMSQ(3, 4)) returns 5, using the Pythagorean theorem to nd the length of the hypotenuse
of a triangle with sides 3 and 4.
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