SUMSQ

Calculates the sum of each number squared from a list of numbers, ranges, or references. Non-numeric values are ignored.

Parameter List

Syntax
SUMSQ(number1
[number2, …]
)
number1

The first number or range whose square to include. For example: 3, A1:A5.

[optional] number2, …

Additional numbers or ranges whose squares to include.

More details

SUMSQ squares each number in the arguments and sums the results. Arguments can be numbers, ranges, or references. Text, empty cells, or logical values are ignored unless typed directly into the arguments.

Examples

SUMSQ(A1:A2) returns 13