Difference between revisions of "Documentation/How Tos/Calc: SUMX2MY2 function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Example:)
m (Robot: Automated text replacement %s)
Line 10: Line 10:
 
:<i>Advanced topic:</i>
 
:<i>Advanced topic:</i>
  
:<tt>'''SUMX2MY2'''</tt> evaluates its parameters <tt>'''x'''</tt> and <tt>'''y'''</tt> as [[Documentation/How_Tos/Using Arrays|array formulas]], but does not need to be entered as an array formula. In other words it can be entered with the '''Enter''' key, rather than '''Cntrl-Shift-Enter'''. See the example below.
+
:<tt>'''SUMX2MY2'''</tt> evaluates its parameters <tt>'''x'''</tt> and <tt>'''y'''</tt> as [[Documentation/How_Tos/Using Arrays|array formulas]] but does not need to be entered as an array formula. In other words it can be entered with the '''Enter''' key, rather than '''Cntrl-Shift-Enter'''. See the example below.
  
 
=== Example: ===
 
=== Example: ===
Line 22: Line 22:
  
 
{{Documentation/SeeAlso|
 
{{Documentation/SeeAlso|
* [[Documentation/How_Tos/Calc: SUM function|SUM]],
+
* [[Documentation/How_Tos/Calc: SUM function|SUM]]
* [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]],
+
* [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]]
* [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]],
+
* [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]]
* [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]],
+
* [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]]
* [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]],
+
* [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]]
 
* [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]]
 
* [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]]
 
* [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]
 
* [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]

Revision as of 14:41, 26 February 2009


SUMX2MY2

Returns the sum of the differences between corresponding squared elements of two matrices.

Syntax:

SUMX2MY2(x; y)

x and y are arrays or ranges of the same size. SUMX2MY2 calculates Calc sumx2my2 equation.png for the i elements in the arrays.
Advanced topic:
SUMX2MY2 evaluates its parameters x and y as array formulas but does not need to be entered as an array formula. In other words it can be entered with the Enter key, rather than Cntrl-Shift-Enter. See the example below.

Example:

SUMX2MY2(A1:A2; {2|1})

where cells A1 and A2 contain 4 and 3 respectively, returns (42-22) + (32-12) = 20.

Advanced topic:

SUMX2MY2(A1:A2+1; {2|1})

when entered 'normally' (not as an array formula), and where cells A1 and A2 contain 3 and 2 respectively, returns ((3+1)2-22) + ((2+1)2-12) = 20. SUMX2MY2 forces (A1:A2+1) to be evaluated as an array formula (internally returning the array {4|3}).

Template:Documentation/SeeAlso

Personal tools