Count Items in List with Excel Pivot Table
If you have a long list of items, you could use formulas to count how many times each item occurs in the list. It would take a few steps, including pulling a list of unique items from the list, then creating a formula to count each item.
I find it quicker and easier to create a pivot table to count the list items. You’ll have to add a heading to the list, if there isn’t one already. Then, create a pivot table from the list, with the same field in the Row Labels area and the Values area.
Watch the Video
To see the steps for using a pivot table to count items in a list, watch this short video.