Today's Tip -- Excel
- Jeanne
- Jun 18, 2016
- 1 min read
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.
Comments