When doing any sort of Subtotal operation, your first step is to Make sure that all of your formatting is correct in the spreadsheet. Sort the data by the field that you wish to apply the subtotal for. Click the Subtotal button and then create a pivot table Create a pivot table Click the Subtotal button