PlanMaker SUMX2PY2: Add Squares from Two Paired Ranges

• 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.

=SUMX2PY2(Range1, Range2)

Both arguments are required ranges or arrays. The current reference defines a sum of x^2+y^2 for corresponding positions. The two inputs must have identical row and column counts, or the function returns #N/A.

A pair is ignored if either value is an empty cell, text or a logical value. This is pairwise exclusion: a valid number on one side is not retained when its counterpart is excluded. Numeric zero remains part of a valid pair.

For ordinary real numbers, included contributions cannot be negative. This total measures combined squared magnitudes; it does not measure the difference between the two ranges.

In a blank worksheet, enter x, y and Sum of squares in A1:C1. Enter A2:B4 as follows:

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

For the complete numeric data, =SUMSQ(A2,A3,A4)+SUMSQ(B2,B3,B4) in E4 also gives 146+26=172. The separate sums are a valid check for this complete table; they are not a substitute for the documented pair-exclusion rule when one side contains missing values.

Enter =(A2+B2)^2 in D2 and fill to D4. Expected results are 100, 16, 144, totaling 260. These include an extra 2xy term in every row and therefore do not equal SUMX2PY2.

Likewise, SUMXMY2 computes (x-y)^2, not x²+y². On the original data its total is 84. Check the actual expression instead of relying on a quick glance at the function names.

Create a separate sheet named Components. Put Horizontal, Vertical, Squared length and Length in A1:D1. Enter 3, 4 in A2:B2 and 5, 12 in A3:B3.

In C2 enter =A2^2+B2^2 and in D2 enter =SQRT(C2); fill both through row 3. Expected squared lengths are 25, 169, and lengths are 5, 13.

In F2 enter =SUMX2PY2(A2:A3,B2:B3); expect 194, the sum of the two squared lengths. In F3 enter =SQRT(F2); expect approximately 13.9283882772. This is the square root of the combined squared magnitudes, not the total of the individual lengths.

In F4 enter =SUM(D2:D3); expect 18. A route length made of two separate segments uses the appropriate sum of segment lengths, not an automatic square root of their squared-length total. The geometry model also requires perpendicular components measured in consistent units.

Changing a component’s sign leaves its square unchanged. On Components, replacing A2 with -3 still gives 25 for that pair and 194 for the total. This loses directional information, so retain the source coordinates when direction matters.

Swapping the two ranges also leaves SUMX2PY2 unchanged. On the original sheet, =SUMX2PY2(B2:B4,A2:A4) in E6 has the same expected result of 172.

For a separate scaling control, put 18, 8, 14 in G2:G4 and 2, 0, 10 in H2:H4. Enter =SUMX2PY2(G2:G4,H2:H4) in J2. The independently expected result is 688, four times 172, because both original ranges were multiplied by two before squaring.

On a separate sheet named PairCheck, enter 9, 4, 7 in A2:A4, 1 in B2 and 5 in B4, leaving B3 genuinely empty. Enter =SUMX2PY2(A2:A4,B2:B4) in D2. Applying the documented exclusion rule gives an expected 156, from 82+74.

Replace B3 with numeric 0; the expected result becomes 172. If B3 instead contains the text missing, that pair is ignored and the expected total is 156 again. A blank counterpart excludes the 4² contribution too.

A three-row column and a three-column row have different dimensions even though both contain three cells. Keep both row and column counts aligned to avoid the documented #N/A condition. Correct dimensions alone do not prove that records are correctly paired after sorting or importing.

The short reference does not define all source-error propagation or extreme numeric precision cases. The examples rely on ordinary numeric pairs and the expressly documented exclusion rule.

SUMSQ handles a single set of squares; SUMX2MY2 subtracts the squared magnitudes. SQRT is useful when the model actually calls for returning from squared units to original units.