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.
The SUMIF and COUNTIF functions return incorrect results when you use them to match strings longer than 255 characters to the string #VALUE!.
This behavior occurs because SUMIF and COUNTIF worksheet functions can accept strings of no more than 255 characters in their criteria arguments.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.