Formula won't recognize data

N

NEHicks

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?
 
S

Sam Wilson

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

Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relating text to a value 1
Sumproduct with three arrays 2
Return Consecutive Values 8
Help with formula Grade book 4
Copying formulas with ranges 2
Trouble with function for multiple data 3
Can't get a formula to work in each row of an Excel sheet. 2
Unique records formula & zero entries 9

Top