Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft.excel.courses.in.london - database functions

Forum 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

ResolvedVersion 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.

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.