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).
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...