You can add subtotals to a list of transactions, such as a list of invoices. To add subtotals to a list of customer names and dollar amounts:
• Sort the list by name. • From the Data ribbon choose Subtotals • Make sure the At each change in field lists the name field. • Choose the type of summary – sum, count, average, etc. • Put a check beside the amount field. • Click OK.
Excel will add the subtotals. To remove them, choose Subtotals again and click Remove All.