XL2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used with Strings Longer Than 255 Characters

Article translations Article translations
Article ID: 231114 - View products that this article applies to.
This article was previously published under Q231114
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Symptoms

The SUMIF and COUNTIF functions return incorrect results when you use them to match strings longer than 255 characters to the string #VALUE!.

Cause

This behavior occurs because SUMIF and COUNTIF worksheet functions can accept strings of no more than 255 characters in their criteria arguments.

Workaround

To work around this issue, avoid using the string #VALUE!, or limit the character string to maximum 255 characters in the function's criteria arguments.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

References

For more information about the SUMIF and COUNTIF functions, click Microsoft Excel Help on the Help menu, type about calculating a value based on a condition in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Properties

Article ID: 231114 - Last Review: October 26, 2013 - Revision: 5.0
Applies to
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB231114

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com