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.

In the next To Do ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.