Count With Pivot Tables in MS Excel

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

Exit mobile version