• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Analyzing Data with Lists > Adding More Subtotals

Adding More Subtotals

You can add any number of subtotals to the current summary. The following procedure shows you what to do:

1.
Choose Data, Subtotals to display the Subtotal dialog box.

2.
Enter the options you want to use for the new subtotal.

3.
Deactivate the Replace Current Subtotals check box.

4.
Click OK. Excel calculates the new subtotals and adds them to the list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint