Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > SUMSQ

 

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

 
 Returns the sum of the squares of the arguments.

 number1The first number.
 number2The second number.
 number3The third optional 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.

     EXAMPLES
     
     A
    1=SUMSQ(3,4) = 25
    2=SUMSQ(12,4) = 160
     

     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top