Microsoft Office Tutorials and References
In Depth Information
Working with Database Functions
What about assigning a name to the criteria area and then using the name as
the third argument to the database function? That works perfectly well, too.
Figure 17-3:
Selecting
criteria to
use with a
database
function.
Whether you use a named area for your criteria or simply type in the range
address, you must be careful to specify an area that includes all the criteria
but does not include any blank rows or columns. If you do, the database
function’s results will be incorrect.
Here’s how you enter any of the database functions. This example uses the
DSUM function, but the instructions are the same for all the database
functions — just use the one that performs the desired calculation.
1. Import or create a database of information on a worksheet.
The information should be in contiguous rows and columns. Be sure to
use field headers.
2.Optionally,usetheNewNamedialogboxtogivethedatabaseaname.
To name your database, see the section “Establishing your database.”
3. Select a portion of the worksheet to be the criteria area, and then add
headers to this area that match the database headers.
You have to provide criteria headers only for database fields that
criteria are applied to. For example, your database area may have ten fields,
but you need to define criteria to three fields. Therefore, the criteria
area can be three columns wide.
4. Position the cursor in the cell where you want the results to appear.
This cell must not be in the database area or the criteria area.
5. Enter =DSUM( to begin the function entry.
6. Enter the database range or a name, if one is set.
7. Enter a comma ( ,).
Search JabSto ::




Custom Search