Formula won't recognize data
 

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?

Formula won't recognize data
 

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?

Formula won't recognize data
 

spaces before/after???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NEHicks" wrote in message
...
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?