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

SUMX2PY2(array_x, array_y)

 
 Returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations.

 array_xThe first array or range of values.
 array_yThe second array or range of values.

 REMARKS
 
  		• The arguments should be either numbers or names, arrays, or references that contain numbers.
     
  		• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  		• If "array_x" and "array_y" have a different number of values, then #N/A is returned.

     EXAMPLES
     
     A
    1=SUMX2PY2({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) = 521
    		 
     Functions - S | Index - S | Office Online 

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