Database(Microsoft Excel Functions)

03/18/2024

Japanese version.

It includes functions primarily for extracting and aggregating data.

Functions.

FunctionImportanceDescription
DAVERAGELowGet the average value by specifying the aggregation items and search conditions.
DCOUNTLowGet the number of numerical counts by specifying the aggregate items and search conditions.
DCOUNTALowGet the number of non-blank cases by specifying the aggregate items and search criteria.
DGETLowGet the value by specifying the item and search criteria.
DMAXLowGet the maximum value by specifying the aggregate items and search conditions.
DMINLowGet the minimum value by specifying the aggregate items and search conditions.
DPRODUCTLowGet the result of multiplication by specifying the aggregate items and search conditions.
DSUMLowTotal values by specifying aggregate items and search criteria.