Excel: Multiple Databases and Criteria in Database Functions

ID: Q23700


The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0, 5.0, 98
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0, 95, 97


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.

Additional query words: 1.5 1.50 2.2 2.20 3.0 3.00 4.0 4.00 5.00 xl95 xl97 xl98

Keywords :
Version : MACINTOSH:1.x,2.x,3.0,4.0,5.0,98; WINDOWS:2.x,3.0,4.0,4.0a,5.0,95,97
Platform : MACINTOSH WINDOWS
Issue type :


Last Reviewed: January 26, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.