O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Using Functions to Extract Details from a List

Excel provides a number of functions that can help you retrieve particular bits of information from your lists. We'll survey those functions in the remainder of this chapter.

The Database Statistical Functions

The database statistical functions include DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP. Each of these functions, with the exception of DGET, is the counterpart of a normal statistical function. DSUM is the counterpart of SUM, DVAR, VAR, and so on.

The difference between the database statistical functions and their counterparts is that the database statistical functions operate on only those members of a range that meet stated criteria. You formulate ...

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