Select the worksheet data.
Go to the Data menu in the ribbon and look in the Outline group.
Click on the Subtotal command.
Select how you want it subtotaled (in our example, this would be by location and for each of the ice cream treat categories).
Click OK.
