The information in this article applies to:
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.
=DSUM(Database1,"field1",Criteria1)"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 : |
Last Reviewed: January 26, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |