Exceljet

Quick, clean, and to the point

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:

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.

Steps

  1. Create a pivot table
  2. Add a category field 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.

Pivot Table Training

If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. Core Pivot is a step-by-step Excel video course that will teach you everything you need to know to use this powerful tool. With a small investment, Pivot Tables will pay you back again and again. See details here.