A Values field is Grouped within your Pivot Table. There are blank cells in your values column within your data set orĢ.There are “text” cells in your values column within your data set orģ. Well, there are three reasons why Pivot Table not counting correctly:ġ. The no1 complaint that I get is “Why do my values show as a Count of rather than a Sumof ?”