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


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q231114

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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB231114
©2003 Microsoft Corporation. All rights reserved.