Count With Pivot Tables in MS Excel


excel logo

Lots of businesses have data tables set up in worksheets but this tip is not just for businesses.

Say you have a large business and have set up a data table of your clients.

In the first column you have the name of your clients and in the second column the cities in which they are located.

Suppose you need to find out how many clients are in each city? One method of doing this is employing a pivot table.

Follow the steps below to learn how:

  1. Select a cell in your data table.
  2. Click on the Insert tab of your Ribbon.
  3. In the Tables group, click the PivotTable tool to display the dialog box.
  4. In the Range box, be certain your entire data table is selected and click on OK. Excel will create an empty PivotTable worksheet for you.
  5. Drag the City field from the field list to the Row Labels area.
  6. Drag the Name field from the field list to the Values area.

Your pivot table is now complete!


Version 2007- 2010

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.