Microsoft KB Archive/231114

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

Article ID: 231114

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

