How to Change From Sum to Count in a Pivot Table

1. Open the PivotTable report in your Microsoft Excel application. Click any cell in the data area so that it’s highlighted.
2. Click the “Field Settings” option on the PivotTable toolbar. The “Sum” option will be selected by default in the PivotTable Field dialog box.
3. Click the “Count” option in the “Summarize by” box. The data will now be summarized by 'count' instead of 'sum.'
4. Click the “Options” button to change any other field settings, such as adding a custom calculation.
5. Click the “OK” button in the PivotTable Field dialog box to save all of your changes.