Pivot tables are an easy way to quickly count values in a data set. In the example shown, a pivot table is used to count the names associated with each color.


The pivot table shown is based on two fields: Name and Color. The Color field is configured as a row field, and the name field is a value field, as seen below:

Pivot table basic count field configuration

The Name field is configured to summarize by count:

Pivot table basic count value field settings

You are free to rename "Count of Name" as you like.


  1. Create a pivot table
  2. Add a category field to the rows area (optional)
  3. Add field to count to Values area
  4. Change value field settings to show count if needed


  1. Any non-blank field in the data can be used in the Values area to get a count.
  2. When a text field is added as a Value field, Excel will display a count automatically.
  3. Without a Row field, the count will be a global count of all data records.