Counting Items In A List Using A PivotTable in Excel

Excel provides a quick way to count items in a list using a PivotTable. Let’s see how:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Here is a list of contest winners by date. I want to know how many times each has won:


An easy way to do this is using a PivotTable. Just highlight the data, go to the Insert tab and insert a PivotTable:


Then just drag the Winner data into both the Rows and Values fields, and voila!, you have your count:


Easy as that!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply