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

Hour 22. Working with Your Database > Working with Subtotals

Working with Subtotals

Now that you have a database to work with, you might want to evaluate your database with the Data, Subtotals option. Excel has several database statistical functions that are similar in design and use Excel's standard statistical functions. Hour 5, “Letting Excel Do the Math,” discusses the standard statistical function in more detail. Some of the common functions are SUM, AVERAGE, MIN, and MAX.

An example of using the SUM function is to find the total amount the company spends on salaries. You would choose the SUM function for the Salary field in the Subtotal dialog box. Excel would display each salary subtotal in the Salary column with the grand total for salaries at the bottom of the Salary column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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