In This Topic

Database Functions

In This Topic

The functions that relate to database and list management are:

DAVERAGE | DCOUNT | DCOUNTA | DGET |

DMAX | DMIN | DPRODUCT | DSTDEV |

DSTDEVP | DSUM | DVAR | DVARP |

These functions apply a mathematical or statistical operation to a subset of values in a range of cells treated as a database. The database table can be thought of as a two-dimensional array organized into rows and columns. Or it can be thought of as a one-dimensional array of records where each record is a structure that has one or more fields. In the context of database tables, the terms "row" and "record" mean the same thing and the terms "column" and "field" mean the same thing. Database refers to a range of cells where the first row in the range represents field labels. The remaining rows in the range represent records. The columns in the range represent fields.

Return to the list of Categories of Functions.