PlanMaker SUMX2MY2: Difference of Squares for Paired Data

• Introduced: Documented by the PlanMaker 2010 manual; the original introduction release is not established.
• Availability: Documented in PlanMaker 2026. This identifies current documented support, not a final working-version endpoint.
• Scope: The reference belongs to the 2026/NX manual family. FreeOffice and individual mobile-build availability are not established here.
• Checked: October 14, 2026, against the official function reference. Expected outputs are vendor examples or independent calculations; no native PlanMaker test was performed.

=SUMX2MY2(Range1, Range2)

Both arguments are required. The official reference defines the sum of x^2-y^2 across corresponding positions. Both ranges must have the same row count and column count; otherwise PlanMaker returns #N/A.

An equal total number of cells is not enough when the shapes differ. For example, a three-row column and a three-column row do not have the same dimensions.

If either member of a pair is blank or is nonnumeric text or a logical value, the entire pair is ignored. A numeric zero is different: it remains an included value. Source-error cells are not covered by that specific exclusion statement.

In a blank worksheet, put x, y and Difference of squares in A1:C1. Fill A2:B4 with these numbers:

Enter =A2^2-B2^2 in C2 and fill through C4. In E2 enter =SUMX2MY2(A2:A4,B2:B4) and in E3 enter =SUM(C2:C4). Both expected results are 120.

For these complete numeric pairs, enter =SUMSQ(A2,A3,A4)-SUMSQ(B2,B3,B4) in E4. Expect 146-26=120. This is a useful cross-check here, but separate sums may include different observations when either side has missing data.

In D2 enter =(A2-B2)^2 and fill through D4. The expected values are 64, 16, 4, totaling 84, not 120. This is the operation performed by SUMXMY2.

Algebraically, x²−y² equals (x-y)*(x+y), whereas (x-y)^2 equals x²−2xy+y². The similarly named functions therefore answer different questions.

Use a separate worksheet named Changes. Put Before and After in A1:B1. Enter 5, 4 in A2:B2 and 4, 5 in A3:B3. Enter =A2^2-B2^2 in C2 and fill to C3. Expected contributions are 9 and -9.

In E2 enter =SUMX2MY2(A2:A3,B2:B3); expect 0. That zero describes a net difference between the two sums of squared magnitudes. It does not mean that each paired value stayed unchanged.

In E3 enter =SUMXMY2(A2:A3,B2:B3); the independent expected result is 2. It captures the two nonzero squared changes without cancellation. Use the statistic that matches the comparison you intend.

Switching the argument order of SUMX2MY2 negates its result. On the original worksheet, =SUMX2MY2(B2:B4,A2:A4) in E6 has expected result -120.

Create a separate worksheet named PairCheck. Put 9, 4, 7 in A2:A4. Put 1 in B2, leave B3 genuinely empty, and put 5 in B4. In D2 enter =SUMX2MY2(A2:A4,B2:B4).

The documented pair-exclusion rule gives an expected 104, from 80+24. The pair containing 4 and the empty cell contributes nothing, rather than contributing 4².

Replace B3 with numeric 0. The expected result becomes 120, because the pair now contributes 16. Replacing B3 with the text missing excludes that pair again and gives an expected 104. These are rule-derived cases, not native execution results.

The omission may hide missing observations in a real report. Confirm the paired records are complete instead of accepting a lower total without checking the data.

Use =SUMX2MY2(A2:A4,B2:B3) on a separate cell only as an intentional error test; the unequal dimensions are documented to produce #N/A. Align records as well as range sizes: a function cannot infer matching IDs or repair a wrongly sorted column.

Exact source-error propagation, extreme-value precision and every scalar coercion case are not specified in the short entry. Keep the worked ranges numeric and compare using full stored values rather than rounded display strings.

SUMSQ handles a single list of squares. SUMX2PY2 adds x² and y² instead of subtracting, while SUM makes the row-by-row check explicit.