Database(Microsoft Excel Functions)
It includes functions primarily for extracting and aggregating data.
Contents
Functions.
| Function | Importance | Description |
|---|---|---|
| DAVERAGE | Low | Get the average value by specifying the aggregation items and search conditions. |
| DCOUNT | Low | Get the number of numerical counts by specifying the aggregate items and search conditions. |
| DCOUNTA | Low | Get the number of non-blank cases by specifying the aggregate items and search criteria. |
| DGET | Low | Get the value by specifying the item and search criteria. |
| DMAX | Low | Get the maximum value by specifying the aggregate items and search conditions. |
| DMIN | Low | Get the minimum value by specifying the aggregate items and search conditions. |
| DPRODUCT | Low | Get the result of multiplication by specifying the aggregate items and search conditions. |
| DSUM | Low | Total values by specifying aggregate items and search criteria. |