Difference between revisions of "Documentation/How Tos/Calc: SUMXMY2 function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(forced arrays) |
(→See also:) |
||
| Line 33: | Line 33: | ||
[[Documentation/How_Tos/Calc: Array functions|'''Array functions''']] | [[Documentation/How_Tos/Calc: Array functions|'''Array functions''']] | ||
| + | |||
| + | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], | ||
| + | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
Revision as of 17:42, 11 September 2008
SUMXMY2
Returns the sum of the squared differences between corresponding elements of two matrices.
Syntax:
SUMXMY2(x; y)
- x and y are arrays or ranges of the same size. SUMXMY2 calculates
for the i elements in the arrays.
- 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:
SUM, SUMIF, SUMSQ, SUMPRODUCT,SUMX2MY2, SUMX2PY2
Conditional Counting and Summation
Functions listed alphabetically, Functions listed by category
