Overview of the Database Functions
This section gives you an overview of the individual database functions and how to use them, as described in Table 13-3.
Table 13-3. Overview of the Database Functions
The Function... | Returns... |
|---|---|
DAVERAGE() | ... the mean of the values matching the condition(s). |
DCOUNT() | ... the number of fields matching the condition(s). |
DCOUNTA() | ... the number of nonempty fields matching the condition(s). |
DGET() | ... a single value matching the condition(s). |
DMAX() | ... the largest value matching the condition(s). |
DMIN() | ... the smallest value matching the condition(s). |
DPRODUCT() | ... the product of the values matching the condition(s). |
DSTDEV() | ... the estimated standard deviation of the values from a sample matching the condition(s). ... |
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
