Database functions
All 10 functions in this category
DSUMDSUM sums values in a database column that meet specified criteria—use it to total filtered column values from a data table.DAVERAGECalculates the average of values in a database field that meet specified criteria, useful for finding filtered averages without creating separate tables.DCOUNTDCOUNT counts cells in a database field that meet specified criteria, returning the total count of matching non-blank cells.DCOUNTACounts non-empty cells in a specified database column for all rows matching your filter criteria, returning the total count.DMAXReturns the maximum numeric value from a database column where all rows match the specified filter criteria conditions.DMINReturns the minimum value in a database field for rows matching criteria, helping find lowest prices, smallest quantities, or minimum values in filtered records.DGETDGET returns a single value from a database/table row matching specified criteria, or an error if multiple rows or no rows match.DPRODUCTDPRODUCT returns the product of all numeric values in a database field that meet your specified selection criteria.DSTDEVReturns the standard deviation of values in a database field that match criteria, showing how much the numeric data spreads out.DVARReturns the variance of values in a database column that match specified criteria, measuring spread in a filtered dataset.