SUMMARY
You can specify more than one database and/or criteria for use with
the database functions [DSUM(), DCOUNT(), and so on] in Microsoft
Excel.
The database functions will accept any reference or named reference
for the Database and Criteria parameters, allowing you to perform any
number of analyses on any number of databases using any number of
criteria.
(NOTE: If you are using Microsoft Excel version 1.5 or earlier, the
database function, database, and criteria must all be located on the
same worksheet.)
For example, enter one of the following:
=DSUM(Database1,"field1",Criteria1)
-or-
=DCOUNT(MyData,"field2",Other)
"Database1" and "MyData" are ranges on the worksheet containing
database information. "Criteria1" and "Other" are ranges on the
worksheet containing criteria.
NOTE: The Data menu's Find, Extract, and Delete commands are valid
only for the database and criteria defined using the Set Database and
Set Criteria commands.