Microsoft KB Archive/140705

= Syntax for DSUM Worksheet Function Is Incorrect =

Article ID: 140705

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q140705



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.



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.

Additional query words: XL

Keywords: KB140705

-

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

© Microsoft Corporation. All rights reserved.