SUMSQ

Syntax:

SUMSQ ( argument-list )

Description: Adds the squares of arguments in argument-list.

Arguments:

Name

Type

Description

argument-list

logical, number, name, text, array, reference

The arguments in argument-list designate the values whose squares are to be summed. Arguments that are numbers, logical values, or text representations of numbers shall be counted. If an argument is an array or reference, only numbers in that array or reference shall be counted. Empty cells, logical values, and text in the array or reference shall be ignored.

Return Type and Value: number – The sum of the squares of its arguments.

example: