Are you absolutely certain that "3A" in column D isn't actually "3A " or
something similar? That's all I can think of.

Sam

"NEHicks" wrote:

I am using the following formulas to count the occurrence of units:
=SUM(($F$555:$F$1085="")*($D$555:$D$1085="5A")). This formula will recognize
all units except 3A. Then it returns 0, which I know is incorrect. In a
separate formula: =(COUNTIF($K$555:$K$1085,"5A")), where K555 is showing
"=D555", this formula will also not recognize 3A but will recognize
everything else.

Both column D and K are formatted as General.

Has anyone heard of this kind of a problem?