Calculates the sum of the squares of the arguments.
Sample Usage
SUMSQ(2,3)
SUMSQ(C5:C7)
Syntax
SUMSQ(value1, [value2,..])
- value1 - The first value or range to consider when calculating the sum of squares.
- value2,.. - [OPTIONAL] Additional values or ranges to consider when calculating the sum of squares.
Examples
SUMSQ(2,3) returns the value 13.
SUMSQ(C5:C7) returns the sum of the squares of the numbers contained in C5:C7.
Notes
- If only a single number for value1 is given, SUMSQ returns the square of value1.
- 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.