SUMSQ

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.microsoft.com
* For the Google documentation refer to support.google.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
6{=SUM({1,2,3,4}^2)} = 30
7{=SUM({1,2}*{3,4})} = 11


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