Database Functions
| DAVERAGE(database,field,criteria) | Returns the average of selected database entries. |
| DCOUNT(database,field,criteria) | Counts the cells containing numbers from a specified database and criteria. |
| DCOUNTA(database,field,criteria) | Counts nonblank cells from a specified database and criteria. |
| DGET(database,field,criteria) | Extracts from a database a single record that matches the specified criteria. |
| DMAX(database,field,criteria) | Returns the maximum value from selected database entries. |
| DMIN(database,field,criteria) | Returns the minimum value from selected database entries. |
| DPRODUCT(database,field,criteria) | Multiplies the values in a particular field of records that match the criteria in a database. |
| DSTDEV(database,field,criteria) | Estimates ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
