Difference between revisions of "Documentation/How Tos/Calc: SUMX2MY2 function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 1: | Line 1: | ||
− | {{Documentation/ | + | {{Documentation/CalcFunc ArraysTOC |
− | | | + | |ShowPrevNext=block |
− | + | |PrevPage=Documentation/How_Tos/Calc:_SUMPRODUCT_function | |
− | + | |NextPage=Documentation/How_Tos/Calc:_SUMX2PY2_function | |
− | + | }}__NOTOC__ | |
− | + | ||
− | + | ||
− | + | ||
− | |PrevPage= Documentation/How_Tos/Calc:_SUMPRODUCT_function | + | |
− | | | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | }} | + | |
− | + | ||
== SUMX2MY2 == | == SUMX2MY2 == |
Revision as of 15:45, 29 January 2024
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 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}).
See Also