Database functions (reference)

Important   The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Click one of the links in the following list to see detailed help about the function.



DAVERAGE function

Returns the average of selected database entries

DCOUNT function

Counts the cells that contain numbers in a database

DCOUNTA function

Counts nonblank cells in a database

DGET function

Extracts from a database a single record that matches the specified criteria

DMAX function

Returns the maximum value from selected database entries

DMIN function

Returns the minimum value from selected database entries

DPRODUCT function

Multiplies the values in a particular field of records that match the criteria in a database

DSTDEV function

Estimates the standard deviation based on a sample of selected database entries

DSTDEVP function

Calculates the standard deviation based on the entire population of selected database entries

DSUM function

Adds the numbers in the field column of records in the database that match the criteria

DVAR function

Estimates variance based on a sample from selected database entries

DVARP function

Calculates variance based on the entire population of selected database entries

See Also

Excel functions (by category)

Excel functions (alphabetical)

Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel Starter, Excel for Android phones

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language