Excel database functions

This article about the introduction of Excel database functions

1.DAVERAGE

Parameter: Returns the average of the values in the column in the database or list that meet the criteria you specify.

Syntax: Daverage (Database,field,criteria)

Parameters: Database makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

2.DCOUNT

Parameters: Returns the number of cells in a specified field in a database or list that meet a given condition and contain numbers.

Syntax: DCOUNT (Database,field,criteria)

Parameters: Database makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

3.DCOUNTA

Parameters: Returns the number of non-null cells in the specified field in the database or list that meet the given criteria.

Syntax: Dcounta (Database,field,criteria)

Parameters: Database makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

4.DGET

Parameter: Extracts a single value from a list or database that matches a specified condition.

Syntax: Dget (Database,field,criteria)

Parameters: Database makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

5.DMAX

Parameters: 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 makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

6.DMIN

Parameters: Returns the smallest number in a cell in a specified column in a list or database that satisfies a given condition.

Syntax: DMIN (Database,field,criteria)

Parameters: Database makes up a range of cells in a list or database. field specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

7.DPRODUCT

Parameter: Returns the product of a number in a specified column of a list or database that satisfies a given condition cell.

Syntax: Dproduct (Database,field,criteria)

Parameters: Ditto

8.DSTDEV

Parameter: The standard deviation of the sample population is estimated as a sample of the number in the column of the list or database that satisfies the specified condition.

Syntax: DSTDEV (Database,field,criteria)

Parameters: Ditto

9.DSTDEVP

Parameter: Calculates the overall standard deviation of a data list or database in a specified column that satisfies a number in a given condition cell as a sample population.

Syntax: DSTDEVP (Database,field,criteria)

Parameters: Ditto

10.DSUM

Parameters: Returns the sum of numbers in a specified column of a list or database that satisfies a given condition cell.

Syntax: DSUM (Database,field,criteria)

Parameters: Ditto

11.DVAR

Parameter: estimates the variance of the population in a specified column of a list or database as a sample of the number in a given condition cell.

Syntax: DVAR (Database,field,criteria)

Parameters: Ditto

12.DVARP

Parameter: Calculates the variance of the population by combining the numbers in the specified column of the list or database that meet the number in the given criteria cell as a sample population.

Syntax: DVARP (Database,field,criteria)

Parameters: Ditto

13.GETPIVOTDATA

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

Syntax: GETPIVOTDATA (pivot_table,name)

Parameters: Data_field 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 defined range of cells in a PivotTable report that determines which data PivotTable report contains the data to retrieve. FIELD1,ITEM1,FIELD2,ITEM2 are 1 to 14 pairs of field names and item names used to describe the retrieved data, which can be arranged in any order.