98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Database Functions
microsoft.excel.courses.in.london - Database Functions
Resolved · Low Priority · Version Standard
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste functions box quicklyIf you want to do a formula using the paste functions box press SHIFT + F3. |