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

Array - conditionally sum the 1st occurence in non-contiguous rang 1
IF AND MATCH data type issue 2
Sumif Formula - Won't Recognize Dates 3
Countif result problem 4
COUNTIF: everything in a row larger than zero over multiple worksh 1
Simplify formula 37
Sum Cells Based on Condition (2 problems) 3
Can't get a formula to work in each row of an Excel sheet. 2

Top