Database functions

Functions in EnglishFunctions in FrenchDescription of Function
DAVERAGEBDMOYENNEReturns the average of selected database entries.
DCOUNTBDNBCounts the cells that contain numbers in a database.
DCOUNTABDNBVALCounts nonblank cells in a database.
DGETBDLIREExtracts from a database a single record that matches the specified criteria.
DMAXBDMAXReturns the maximum value from selected database entries.
DMINBDMINReturns the minimum value from selected database entries.
DPRODUCTBDPRODUITMultiplies the values in a particular field of records that match the criteria in a database.
DSTDEVBDECARTYPEEstimates the standard deviation based on a sample of selected database entries.
DSTDEVPBDECARTYPEPCalculates the standard deviation based on the entire population of selected database entries.
DSUMBDSOMMEAdds the numbers in the field column of records in the database that match the criteria.
DVARBDVAREstimates variance based on a sample from selected database entries.
DVARPBDVARPCalculates variance based on the entire population of selected database entries.