Database Functions
What are Database Functions and how are they created?
RE: Database Functions
Answer to the question:
Database functions are used to extract/filter information from an Excel Database or List, they all follow the same syntax and are able to filter complex criteria which is user defined.
The syntax is as follows, =dfunction(range to test, column to perform calculation within, criteria list range). for example: =DSUM(A1:H25,6,J1:L4). Names can be used to substitute for Cell References.
The type of Dfunctions available include the "Big Five" DSUM, DCOUNT and (DCOUNTA), DAVERAGE, DMAX and DMIN, These can be used as required. the Criteria List range must include the Field Heading matching the Excel List, and can use the numeric calculators, =, >, <, <>, >=, <=.
The Naming of cells and ranges, and the creating and using of Database Functions are covered on the Excel Advanced Course.