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.

 
 
 

Recent Posts

See All

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