Excel Tutorial (4)-Database functions

Daverage

Purpose: Returns the average of the values in the column in the database or list that meet the specified criteria.
Syntax: Daverage (Database,field,criteria)
Parameters: Database is a range of cells that make up a list or a db. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain a given condition.

DCOUNT

Purpose: Returns the number of cells in a specified field of a database or list that meet a given condition and contain numbers.
Syntax: DCOUNT (Database,field,criteria)
Parameters: Database is a range of cells that make up a list or a db. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain a given condition.

Dcounta

Purpose: Returns the number of non-empty cells in a specified field in a database or list that meet a given condition.
Syntax: Dcounta (Database,field,criteria)
Parameters: Database is a range of cells that make up a list or a db. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain a given condition.

DGET

Purpose: Extracts a single value from a list or database that meets the specified criteria.
Syntax: DGET (Database,field,criteria)
Parameters: Database is a range of cells that make up a list or a db. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain a given condition.

DMAX

Purpose: Returns the maximum number in a specified column of a list or database that satisfies a given condition cell.
Syntax: DMAX (Database,field,criteria)
Parameters: Database is a range of cells that make up a list or a db. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain a given condition.

Dproduct

Purpose: Returns the value product of a given condition cell in a specified column of a data list or database.

Syntax: Dproduct (Database,field,criteria)

Parameter: Ibid.

DSTDEV

Purpose: Estimates the standard deviation of the sample population by the number of columns in the list or database that meet the specified criteria as a sample.
Syntax: DSTDEV (Database,field,criteria)
Parameter: Ibid.

DSTDEVP

Parameters: Calculates the standard deviation of the population in the specified column of a list or database that satisfies the number in a given condition cell as a sample population.
Syntax: DSTDEVP (Database,field,criteria)
Parameter: Ibid.

DSUM

Purpose: Returns the sum of the numbers in a given condition cell, in the specified column of a list or database.
Syntax: DSUM (Database,field,criteria)

Parameter: Ibid.

DVAR

Purpose: Estimates the variance of a sample population by the number in the specified column of a list or database that satisfies a given condition cell as a sample.
Syntax: DVAR (Database,field,criteria)

Parameter: Ibid.

DVARP

Purpose: Calculates the variance of the population by the number in the specified column of a list or database that satisfies a given condition cell as a sample population.
Syntax: DVARP (Database,field,criteria)

Parameter: Ibid.

GETPIVOTDATA

Purpose: Returns the data stored in the PivotTable report. If the summary data in the report is visible, you can use the function GETPIVOTDATA to retrieve the summarized data from the PivotTable report.

Syntax: GETPIVOTDATA (pivot_table,name)

Parameter: Data_field is the name of the data field that contains the data to retrieve (enclosed in quotation marks). Pivot_table a reference to any cell, range of cells, or range of cells defined in a PivotTable report, which is used to determine which data PivotTable contains the data to retrieve. Field1,item1, FIELD2,ITEM2 is 1 to 14 for the field names and item names that describe retrieving data, which can be arranged in any order.

Excel Tutorial (4)-Database functions