Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel - Database functions - Chapter 6 - Coggle Diagram
Excel - Database functions - Chapter 6
If you require a calculation to be performed only on certain records in a database you can either:
Create a sample using a filter to extract the records meeting the criteria and then perform the calculation on the sample, or
You can use a database function
There are four components involved in the performance of a database function:
Database formula
Database or data range (including headings)
The criteria (simple or complex)
Output
-Dfunction(database, column#, criteria)
Column#
The column number in which you will find the value you want to display
Criteria
The criteria are the same as for filters
Database
The database range specified in the function is the same as for filters. Remember your database will need on row of headings and exclude totals and balances
Dmax
Searches and gives the maximum value in a column as output that meets certain criteria
=Dmax(database, column#, criteria)
Dcount
Counts the records (cells) that contain numerical values in a database that meets certain criteria
=Dcount(database, column#, criteria)
Dmin
Searches and gives the minimum value in a column as output that meets certain criteria
=Dmin(database, column#, criteria)
Daverage
Calculate the average of values in a column in a database that meets certain criteria
=Daverage(database, column#, criteria)
Dcounta
Counts the number of records (cells) containing numerical and alphanumerical values in the database that meets certain criteria
=Dcounta(database, column#, criteria)
Dsum
Add values in a column of the database according to the prescribed criteria
=Dsum(database, column#, criteria)