O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required