How to Access a Pivot Table Count
- 1). Click the worksheet tab in the Excel spreadsheet that has your pivot table data.
- 2). Click the field next to the cell that contains the data that you want to count.
- 3). Right-click and choose "Summarize values by."
- 4). Select "Count" from the list.
- 5). Check the count in your pivot table.