The
SUMSQ() function returns the squares
of the arguments, summed.
- The syntax for
the function is SUMSQ (number,
number,.... number_n).
The
arguments for the function "number1,
number2,.... number_n" can
be a series of up to 30 numbers, referenced
ranges of cells, a single array or
named range. Text representations
of numbers and logical values are
recognized only when entered dirtectly
in the function. However arguments
that cannot be translated into numbers
will cause a #VALUE error to be returned.
The SUMSQ
function square number and then
finds the sum of these squares.
- For
example: SUMSQ({3,5,4})
= 50.
The sum
of each squared argument is:.
i.e. (3*3)+(5*5)+(4*4) = (9)+(25)+(16)
= 50.
|
Note: Arguments in
cells can only be numeric values (text,
logical values, empty cells and error values
are ignored). The sum of the squares of
arguments in an array can also be found
using the SUMPRODUCT function. e.g. SUMPRODUCT({2,5,1}^2)
= 30.
|
