You measured three checkpoints and want a single number that grows with the size of the misses. Adding signed differences can make a high reading cancel a low one. Squaring the paired differences keeps both misses in the total.
Match the readings row by row
In B2:B4, put targets 20, 22 and 24. In C2:C4, put observed values 21, 20 and 24. Check the checkpoint labels before using:
=SUMXMY2(C2:C4,B2:B4)
Illustrated pairs. Confirm both columns use the same units and checkpoint order.
Inspect the contribution from each pair
The differences are 1, −2 and 0. Their squares are 1, 4 and 0, so the result is 5. It is a sum of squared differences, in squared units. If someone needs to see which checkpoint ran low, keep the signed difference in another column.

Illustrated reconciliation. The largest miss contributes four units squared.
Make sure the inputs have the same units and order. Resolve missing readings explicitly before comparing totals across different groups of checkpoints.



