Home › Functions › Database
⇄

Database · Compatibility

53 functions in this category · showing 12 available

Filter in full list
Database ★ 4 · ◉ 13 · All versions

=DSTDEV()

Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

=DSTDEV(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 25 · ◉ 12 · All versions

=DAVERAGE()

Averages the values in a field (column) of records in a list or database that match conditions you specify.

=DAVERAGE(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 30 · ◉ 11 · All versions

=DGET()

Extracts a single value from a column of a list or database that matches conditions that you specify.

=DGET(database, field, criteria)
Lookup & Retrieval
Examples → Description
Database ★ 25 · ◉ 7 · All versions

=DCOUNT()

Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.

=DCOUNT(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 3 · ◉ 6 · All versions

=DPRODUCT()

Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.

=DPRODUCT(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 3 · ◉ 6 · All versions

=DSTDEVP()

Calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

=DSTDEVP(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 25 · ◉ 5 · All versions

=DCOUNTA()

Counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria.

=DCOUNTA(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 25 · ◉ 5 · All versions

=DMAX()

Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.

=DMAX(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 3 · ◉ 5 · All versions

=DVAR()

Estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

=DVAR(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 3 · ◉ 5 · All versions

=DVARP()

Calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

=DVARP(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 25 · ◉ 4 · All versions

=DMIN()

Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.

=DMIN(database, field, criteria)
Conditional Aggregation
Examples → Description
Database ★ 35 · ◉ 3 · All versions

=DSUM()

In a list or database, DSUM provides the sum of the numbers in fields (columns) of records that match your specified conditions.

=DSUM(database, field, criteria)
Conditional Aggregation Reporting
Examples → Description