Excel Guides

Counting with Pivot Tables in Excel

Pivot tables are one of the most powerful tools in Excel. They allow you to quickly summarize large amounts of data and make better decisions. In this article, we'll show you how to use pivot tables to count things in Excel.

First, let's take a look at an example. Say we have a list of students and their grades. We want to know how many students got each grade. We can create a pivot table to do this.

In the example above, we created a pivot table with the following fields:

  • Name: This is the name of the student.
  • Grade: This is the grade that the student got.

We placed the Name field in the Row Labels area and the Grade field in the Values area. This generated a count of how many students got each grade.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.