top of page
Search

Today's Tip -- Excel

Jeanne

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.

9 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...

Address

93 W Bluebell Ln

Mount Laurel, NJ  08054

Call

T: 888-764-7117

F: 609-543-1164 

© 2019 by

ASC Inc

Proudly created with Wix.com

  • facebook
  • Twitter Clean
  • w-googleplus
bottom of page