The Excel Sumsq function returns the sum of squares of a supplied set of
values.
Syntax
The syntax for the SUMSQ function in Microsoft Excel is:
=SUMSQ( value1,
[value2, ... value_n] )
Parameters or Arguments
value1, value2, ... value_n
A series of numeric values that are to be squared and then summed
together. There can be up to 30 values.
Sumsq Function Examples
The spreadsheets below show two examples of the Sumsq function.
Formulas:
|
|
A
|
B
|
|
1
|
Values
|
Sumsq
|
|
2
|
5
|
=SUMSQ(
A2:A5 )
|
|
3
|
2
|
=SUMSQ(
A2, A3, A4, 6 )
|
|
4
|
1
|
|
|
5
|
3
|
|
Results:
|
|
A
|
B
|
C
|
|
1
|
Values
|
Sumsq
|
|
|
2
|
5
|
39
|
= 5^2 +
2^2 + 1^2 + 3^2
|
|
3
|
2
|
66
|
= 5^2 +
2^2 + 1^2 + 6^2
|
|
4
|
1
|
|
|
|
5
|
3
|
|
|
The above examples show how:
-
The
arguments to the Sumsq function can be input directly or as references to cells
containing values;
-
Each of
the arguments can be an individual value or an array of values.
Note
-
In
current versions of Excel (Excel 2007 and later), you can provide up to 255
number arguments to the Sumsq function, but in Excel 2003, the function can
only handle up to 30 number arguments.
-
Arguments
can either be numbers or names, arrays, or references that contain numbers.
-
Numbers,
logical values, and text representations of numbers that you type directly into
the list of arguments are counted.
-
If an
argument is an array or reference, only numbers in that array or reference are
counted. Empty cells, logical values, text, or error values in the array or
reference are ignored.
-
Arguments
that are error values or text that cannot be translated into numbers cause
errors.
References
No comments:
Post a Comment