SUMSQ(number1, number2 [,number3] [..])

Returns the sum of the squares of all the values in a list, table or cell range.

number1The first number.
number2The second number.
number3(Optional) The third number.

* The arguments can be numbers, arrays, names or cell references that contain numbers.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* You can have a maximum of 30 arguments.
* For the Microsoft documentation refer to

1=SUMSQ(1,1) = 2
2=SUMSQ(2,2) = 8
3=SUMSQ(3,4) = 25
4=SUMSQ(12,4) = 160
5=SUMSQ(5,10) = 125

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top