Excel Just Summed Your ID Numbers and Said Nothing

Drop a column into a pivot's Values and Excel picks Sum for anything numeric, including ID codes. The test that catches it, and the ten-second fix.