Investment Studio > Expressions > Functions > Math & Trig > SUMSQ

float sumsq(float data [, ...])

Returns the sum of the squares of those arguments which are (or can be converted to) real numbers.

The input data may include arrays, in which case each array element will be treated as a separate argument.

Example

=sumsq(5, 6, {{7, "8"}, {TRUE, "This is not a number!"}})

equals 175: "8" is converted to 8; TRUE is converted to 1; "This is not a number!" doesn't convert, so it's ignored (note that this is not an error condition).

See also average, count, counta, product, sqr, sum, sumif, sumproduct.