SUMSQ

See also A-Z Spreadsheet Function List

Description Squares each of the supplied numbers and returns the sum of the squares.

Syntax SUMSQ(number_list)

number_list is a list of as many as 30 numbers, separated by commas.

The list can contain numbers, logical values, text representations of numbers, or a reference to a range containing those values.

Error values or text that cannot be translated into numbers return errors.

If a range reference is included in the list, text, logical expressions, and empty cells in the range are ignored.

See Also SUM function

Example SUMSQ(9, 10, 11) returns 302