Use of Array Constants with the =DSUM Function in Excel

 Last reviewed: November 2, 1994
Article ID: Q45075
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

SUMMARY

This article discusses using an array constant with the =DSUM function, passing multiple fields, and calculating the =DSUM of two different columns.

MORE INFORMATION

The database functions require three parameters: database, field, and criteria. All three of these are required. For the database and criteria parameters, use the references data type; for the field parameter, you must pass text. With the array constant, you can send text as a constant.

To enter a =DSUM formula, do the following:

  1. Select a column of cells with the same number of cells as the number of values in your array constant.

  2. Enter the formula, as shown in the following example: 

          =DSUM(database,{"fieldname1";"fieldname2"...},criteria)

    substituting fieldname1, fieldname2, etc. with the desired fieldnames in your database,

  3. Press CTRL+SHIFT+ENTER to enter the formula as an array.

In this example, be sure to use a semicolon in the array constant. The semicolon tells Excel to return the values down a column. If you wish to return the results to a row of cells, replace the semicolons with commas.

KBCategory: kbusage
KBSubcategory:

Additional words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00
3.0 4.00 4.0 4.0a 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.