Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Counting with PivotTables.
Suppose you have a data table set up in Excel that represents your club membership. In the first column are the names of club members. In the second column are the cities in which the members live. If you want to find out how many people live in each city, there are several methods you can choose. One method is to create a PivotTable.
To create a PivotTable on your data, follow these steps:
Figure 1. The Create PivotTable dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6160) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Counting with PivotTables.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Are you attached to the classic PivotTable layout? Looking for a way to make that layout the default for new PivotTables? ...
Discover MoreNeed to reduce the size of your workbooks that contain PivotTables? Here's something you can try to minimize the ...
Discover MorePivotTables are great for digesting and analyzing huge amounts of data. But what if you want part of that data excluded, ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-07-16 05:53:21
Eldad
I have a list of 468 zip codes from a mailing list. I want to count the number of listings for each zip code listed: in other words, about half of the list is in 01257, but there are high concentrations in adjacent zip codes, and then two or three in each of about a dozen. How do I get Excel to (a) identify the individual codes without me listing them by number and COUNTing them, and (b) how do I get Excel to count the frequencies of each zip code?
I want Excel to build me a chart of frequency statistics without me lifting more than an index finger.
Thanks.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments