You don't even have to remove the subtotals first. To reclaim the previous lists, select the spreadsheet, press Ctrl+L, and click OK to close the Create List dialog box. In this case, Salesperson is the group, so Excel displays a subtotal for both Susan and Bill. This feature inserts a subtotaling row and result for each group as specified in the Subtotals dialog box. After specifying the right columns and functions, click OK.Check the appropriate columns in the Add Subtotal To section.Sum is the default, and in this case, the desired function. From the Use Function control, select the appropriate function.In this case, that's the Salesperson column. From the At Each Change In control, choose the column by which you're subtotaling (not the column that contains the values you're subtotaling).In the Subtotal dialog box, you have a number of choices: Excel 2007 users should click Subtotal in the Outline group on the Data tab. In Excel 2003, choose Subtotals from the Data menu.Now you're ready to add subtotals, as follows: Why they made sorting so difficult in 2007, I haven't a clue. Excel 2007 users much select a specific sort by clicking Sort and Filter in the Editing group on the Home tab. In Excel 2003 and earlier, click Sort Ascending or Sort Descending, accordingly.For instance, to subtotal the Total column by Salesperson, you must first sort the data by Salesperson, as follows: Once you have a conventional range, sort the data according to your subtotaling needs. Excel 2007 users should click the Design tab and click Convert To Range in the Tools group. In Excel 2003, choose Lists from the Data menu and select Convert To Range.