Forum Discussion
Pivot Table Summing ID Number
I am trying to make a Pivot Table, but my ID number keeps being summed. I changed the column to not be read as a number, rather as text - but it continues to sum the ID Number. Any suggestions on how ...
Don't put your ID number in the Values field, but instead in the Row Labels field. If you are trying to count ID numbers then change the calculation by clicking on ID in the Value Field area and using the Options.
That’s what I ended up doing on my Mac, but I was working on a PC and that wasn’t an option. Perhaps older version of Excel. Any suggestions for this problem on a PC?