SUMSQ

  • Updated

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.