XL: Syntax for DSUM() Worksheet Function Is Incorrect

ID: Q140705

The information in this article applies to:

Microsoft Excel for Windows, version 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.

Additional query words:

Keywords : xlwin
Version : WINDOWS:5.0; Win95:7.0
Platform : Win95 WINDOWS
Issue type :