Data -> Outline-> Subtotal Data: Subtotal The list has been Sorted by City. Now, here are the steps to Subtotal by City.   2. Try it: Subtotal the Data Select Column E (City). Go to Data ->Outline->Subtotal.   You will be prompted to answer the following questions for this Subtotal:   At each change: City. You just sorted by City, select City for the Subtotal so it matches.   Use function: Count.   Add the subtotal to: City. The Subtotal is counting the number of customers in each city. It makes sense to add the Subtotal to the City.   Click OK. Keep going...   Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.2. Apply data analysis: Subtotal