Syntax for DSUM() Worksheet Function Is Incorrect (140705)

The information in this article applies to:

Microsoft Excel for Windows 95
Microsoft Excel for Windows 5.0

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.

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.

Modification Type:	Minor	Last Reviewed:	8/17/2005
Keywords:	KB140705