Difference between revisions of "Documentation/How Tos/Calc: SUMXMY2 function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(5 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:SUMXMY2 function}} |
+ | {{Documentation/CalcFunc ArraysTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_SUMX2PY2_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_TRANSPOSE_function | ||
+ | }}__NOTOC__ | ||
== SUMXMY2 == | == SUMXMY2 == | ||
Line 21: | Line 26: | ||
: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}). | ||
− | {{ | + | {{SeeAlso|EN| |
* [[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]] | ||
Line 33: | Line 38: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Array functions]] |
Latest revision as of 10:50, 30 January 2024
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}).
See Also