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

Displaying Subtotals

To subtotal a list, follow these steps:

1.
If you haven't already done so, sort your list according to the groupings you want to use for the subtotals.

2.
Convert the list to a normal range by choosing Data, List, Convert to Range, and then choosing Yes when Excel asks you to confirm.

3.
Choose Data, Subtotals to display the Subtotal dialog box, shown in Figure 13.20.



Figure 13.20. You use the Subtotal dialog box to create subtotals for your list.


4.
Enter the options you want to use for the subtotals:

  • At Each Change In— This box contains the field names for your list. Click the field you want to use to group the subtotals.

  • Use Function— Select the function you want to use in the calculations. Excel gives you 11 choices, including Sum, Count, Average, Max, and Min.

  • Add Subtotal To— This is a list of check boxes for each field. Activate the appropriate check boxes for the fields you want to subtotal.

  • Replace Current Subtotals— Activate this check box to display new subtotal rows. To add to the existing rows, deactivate this option.

  • Page Break Between Groups— If you intend to print the summary, activate this check box to insert a page break between each grouping.

  • Summary Below Data— Deactivate this check box if you want the subtotal rows to appear above the groupings.

5.
Click OK. Excel calculates the subtotals and enters them into the list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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