Today's Tip -- Excel

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.

#QuickBooks #Sage50 #Excel

8 views0 comments

Recent Posts

See All

Do you know how to link Excel Spreadsheets?

If you work with multiple spreadsheets in Excel, and need to transfer data from one to the other, or summarize in one workbook data from others, you can set up the summary worksheet to automatically p