XL: Syntax for DSUM() Worksheet Function Is Incorrect

 Last reviewed: September 13, 1996
Article ID: Q140705
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel, Help contains incorrect information about the DSUM() worksheet function. It uses the function name DMAX rather than DSUM. This information is incorrect. The correct syntax for this function is as follows: 

   DSUM(database, field, criteria)
   Database     is the range of cells that make up the database.
   Field        indicates which field is used in the function.
   Criteria     is the range of cells that contains the database criteria.

STATUS

This problem was corrected in Microsoft Excel version 5.0c.

MORE INFORMATION

Microsoft Excel 7.0

For more information about the DSUM function, click the Index tab in Microsoft Excel 7.0 Help, type the following text 

   DSUM
and then double-click the selected text to go to the "DSUM" topic.

Microsoft Excel 5.0

For more information about the "DSUM function," choose the Search button in Microsoft Excel 5.0 Help, and type: 

   DSUM
Choose the Show Topics button, select the topic, and choose Go To.

KBCategory: kbprb kbdocerr
KBSubcategory: xlwin

Additional reference words: 5.00 7.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: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.