SUMX2MY2 in Collabora Office: Compare Paired Squares Without Confusing Squared Differences

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independently derived controls; no native Collabora test was performed.

=SUMX2MY2(arrayX;arrayY)

The official Collabora section states that the first array’s elements are squared and added, and the second array’s elements are squared and subtracted. Use aligned numeric ranges with the same shape in these controls.

The array-function page lists SUMX2MY2 among functions with forced array handling when area references are supplied. These examples pass ranges directly and return one aggregate; they do not ask for a separate output cell per pair. English names and semicolon separators are used.

Prepare A1:D5 with the following data. The final two columns show explanatory calculations; enter their formulas after entering X and Y.

Put =A2^2 in C2 and =B2^2 in D2, then fill both down. In a separate result cell enter:

=SUMX2MY2(A2:A5;B2:B5)

Expected result: 14. The paired differences are 8, 12, 3 and −9. Their sum is 14; an individual pair is allowed to contribute a negative number.

=SUMX2MY2(B2:B5;A2:A5)

Expected result: −14. Reversing the roles reverses the sign. In the original orientation, the X squares total 29 and the Y squares total 15, so a transparent check is 29−15=14.

The result compares aggregate squared magnitudes. It does not directly measure an ordinary signed change in the unsquared source values.

In a separate area enter X values 3, 4 and Y values 0, 5. Then the squared totals are both 25:

=SUMX2MY2(H2:H3;I2:I3)

With those two columns in H and I, the expected result is 0. Neither pair is equal: the contributions are 9 and −9, which cancel.

If the question is whether every numerical pair matches, use a rowwise equality check or inspect SUMXMY2 under its numeric assumptions. Zero difference between two sums of squares does not imply zero squared differences.

For X values 3, 4 and Y values −3, −4, SUMX2MY2 again has expected result 0. Squaring removes each original sign before comparison.

The corresponding sum of squared differences is 100, because the differences are 6 and 8. Thus the two similarly named functions can yield zero and 100 on the same source data while both are doing their documented jobs correctly.

For the original four-row control, negating every X value leaves SUMX2MY2 at 14. Keep the original signed values if orientation matters to a later calculation.

Preserve row identities when copying or sorting paired data. The definition refers to corresponding positions; same-sized ranges alone do not establish that the rows represent the intended observations.

These controls contain numbers in every selected position and use matching range shapes. The direct section does not establish the complete mismatch, text, blank or error-handling matrix, so this guide does not promise that all such inputs are ignored or assign unverified native error codes.

SUMX2PY2 adds the two squares instead of subtracting them. Spell out the intended per-row expression before choosing among the three names. Very large squares or cancellation between nearly equal totals can introduce precision concerns beyond these small independent controls.

• Collabora Office 26.04: SUMX2MY2.
• Editorial testing standards.

The direct function section and array-handling introduction were reviewed. Worked numeric controls were independently calculated, without native application execution or broader client certification.