Difference between revisions of "Documentation/How Tos/Calc: SUMXMY2 function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 10: | Line 10: | ||
:<i>Advanced topic:</i> | :<i>Advanced topic:</i> | ||
− | :<tt>'''SUMXMY2'''</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>'''SUMXMY2'''</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 19: | Line 19: | ||
<tt>'''SUMXMY2(A1:A2+1; {2|1})'''</tt> | <tt>'''SUMXMY2(A1:A2+1; {2|1})'''</tt> | ||
− | :when entered 'normally' (not as an [[Documentation/How_Tos/Using Arrays|array formula]]), and where cells A1 and A2 contain <tt>'''3'''</tt> and <tt>'''2'''</tt> respectively, returns ((3+1)-2)<sup>2</sup> + ((2+1)-1)<sup>2</sup> = <tt>'''8'''</tt>. <tt>'''SUMXMY2'''</tt> forces <tt>'''(A1:A2+1)'''</tt> to be evaluated as an [[Documentation/How_Tos/Using Arrays|array formula]] (internally returning the array {4|3}). | + | :when entered 'normally' (not as an * [[Documentation/How_Tos/Using Arrays|array formula]]), and where cells A1 and A2 contain <tt>'''3'''</tt> and <tt>'''2'''</tt> respectively, returns ((3+1)-2)<sup>2</sup> + ((2+1)-1)<sup>2</sup> = <tt>'''8'''</tt>. <tt>'''SUMXMY2'''</tt> forces <tt>'''(A1:A2+1)'''</tt> to be evaluated as an * [[Documentation/How_Tos/Using Arrays|array formula]] (internally returning the array {4|3}). |
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: SUM function| | + | * [[Documentation/How_Tos/Calc: SUM function|SUM]], |
− | [[Documentation/How_Tos/Calc: SUMIF function| | + | * [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], |
− | [[Documentation/How_Tos/Calc: SUMSQ function| | + | * [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]], |
− | [[Documentation/How_Tos/Calc: SUMPRODUCT function| | + | * [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]],* [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], |
− | [[Documentation/How_Tos/Calc: SUMX2PY2 function| | + | * [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]] |
− | [[Documentation/How_Tos/Conditional Counting and Summation| | + | * [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]] |
− | [[Documentation/How_Tos/Using Arrays| | + | * [[Documentation/How_Tos/Using Arrays|How To Use Arrays in Calc]] |
− | [[Documentation/How_Tos/Calc: Array functions| | + | * [[Documentation/How_Tos/Calc: Array functions|Array functions]] |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 14:21, 25 February 2009
SUMXMY2
Returns the sum of the squared differences between corresponding elements of two matrices.
Syntax:
SUMXMY2(x; y)
- Advanced topic:
- SUMXMY2 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:
SUMXMY2(A1:A2; {2|1})
- where cells A1 and A2 contain 4 and 3 respectively, returns (4-2)2 + (3-1)2 = 8.
Advanced topic (parameter evaluated as array formula):
SUMXMY2(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)2 + ((2+1)-1)2 = 8. SUMXMY2 forces (A1:A2+1) to be evaluated as an * array formula (internally returning the array {4|3}).