Pivot table basic count

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.

Fields

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:

The Name field is configured to summarize by count:

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

Steps

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

Notes

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.