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:

ptc1

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

ptc2

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

ptc3

Easy as that!

Happy Excelling!

Related Post

Free Download!

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

, , ,

No comments yet.

Leave a Reply