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