Database(Microsoft Excel Functions)

Japanese version. It includes functions primarily for extracting and aggregating data. 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 … Continue reading Database(Microsoft Excel Functions)