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

Chapter 15. Excel Database Techniques > Totaling Numeric Data in a Database

Totaling Numeric Data in a Database

For any numeric list in the database, you can create subtotals and totals.

To total numeric data in the database:

1.
Select any cell in the database.

2.
From the Data menu, choose Subtotals.

3.
In the Subtotal dialog box, select a field from the At each change in drop-down list (Figure 15.14).

Figure 15.14. Select the fields in the Subtotal dialog box.


4.
Click OK.

A subtotal appears each time this field changes value. A grand total appears at the bottom of the list (Figure 15.15).

Figure 15.15. Click the minus buttons to hide detail and show only the totals.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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