By Michael Nocito, data analyst · Published August 7, 2026
This article gives you the test that catches the most common beginner mistake in pivot tables, and the ten-second fix. The test is one line: would adding two of these together mean anything? If the answer is no, the column is a label, and it must never be summed.
The mistake happens without you doing anything wrong. You drag a column into a pivot's Values area, and Excel decides, on its own, how to summarize it. For anything numeric, it picks Sum. If that column was an ID, you now have the sum of a set of ID codes, printed with the same confidence as revenue.
The short version. Some columns are labels wearing a number's clothes: IDs, zips, years, phone numbers, invoice numbers. Count them or group by them, never sum them. The fix is Value Field Settings, Sum to Count.
This is not hypothetical. In the build behind this series, over 82,956 Steam games, this exact trap fired in step 3, survived a first glance, and was caught by a check cell. Then it turned up in three more fields on the same page.
