Spread Formula Reference
Formula Overview / Functions in a Formula / Categories of Functions / Database Functions
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.