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.

Remarks

* 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 support.office.com

 A
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


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