DAVERAGE function is used to get average from the database for the field you want by applying criteria or condition Syntax of DAVERAGE Function =DAVERAGE(database,field,criteria) Arguments of DAVERAGE Function database…
DCOUNT function is used to get count from the database for the field you want by applying criteria or condition Syntax =DCOUNT(database,field,criteria) Arguments database: The range of the data in the first row contai…
DGET function is used to get value from the database specified condition which is applied in criteria. DGET Function will return single value. Syntax of DGET Function =DGET(database,field,criteria) Arguments of …
DMAX function is used to get maximum value from the database specified condition which is applied in criteria. DMAX Function will return maximum value. Syntax of DMAX Function =DMAX(database,field,criteria) Arguments o…
DMIN function is used to get minimum value from the database specified condition which is applied in criteria. DMIN Function will return minimum value. Syntax of DMIN Function =DMIN(database,field,criteria) Arguments o…
DPRODUCT function is used to get a product of the values from the database specified condition which is applied in criteria. DPRODUCT Function will return the product of the conditional records. Syntax of DPRODUCT FUnction …
DSUM function is used to get a sum of the values from the database specified condition which is applied in criteria. DSUM Function will return the sum of the conditional records. Syntax of DSUM Function =DSUM(database,fie…
