Microsoft KB Archive/23700

= Multiple Databases and Criteria in Database Functions =

Article ID: 23700

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 4.0a
 * Microsoft Excel 3.0 Standard Edition
 * Microsoft Excel 2.10d
 * Microsoft Excel 2.1 Standard Edition
 * Microsoft Excel 2.01
 * Microsoft Excel 2.0 Standard Edition
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 4.0 for Macintosh
 * Microsoft Excel 3.0 for Macintosh
 * Microsoft Excel 2.2a
 * Microsoft Excel 1.5a for Macintosh
 * Microsoft Excel 1.06 for Macintosh
 * Microsoft Excel 1.04 for Macintosh
 * Microsoft Excel 1.03 for Macintosh
 * Microsoft Excel 1.0 for Macintosh

-



This article was previously published under Q23700



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 Excel

Keywords: KB23700

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.