Click Here to Drop Your Doubts
Summary: In this class, Jaywant Sir will be explaining Data Base Function.
Process: Dcount: =dcount(Database, Field, Criteria)
Dcount is used to calculate the minimum value. Counts the cells that contain numbers in a field (column) of records in a list or database that match the conditions that you specify.
DcountA: =dcounta(Database, Field, Criteria)
DcountA is used to calculate the minimum value. Counts the cells that contain alphabets in a field (column) of records in a list or database that match the conditions that you specify.
DAVERAGE: =daverage(Database, Field, Criteria)
Daverage is used to calculate the average value. Counts the cells that contain numbers and alphabets in a field (column) of records in a list or database that match the conditions that you specify.
Dmax: =dmax(Database, Field, Criteria)
Dmax function returns the largest number in a column in a list or database, based on given criteria. The DMAX function is a built-in function in Excel that is categorized as a Database Function.
Dmin: =dmin(Database, Field, Criteria)
Dmin is used to calculate the minimum value in a column in a list or database, based on given criteria. The DMIN function is a built-in function in Excel that is categorized as a Database Function.
Conclusion: After completion of this class you will be able to do database functions which are as follows Dcount, DcountA, Daverage, Dmax, and Dmin.
