Sumif formula not working - Excel emergency!

[DogGoneGood]

I am trying to do a sumif in excel and am getting the incorrect results. As seen in the below table. I am doing a sumif to return the sum of values for particular codes that begin with the number zero. Excel is summing up the values for both codes 0E1 and 0E2 instead of treating these codes as unique. How can I resolve this? Your prompt response would be greatly appreciated.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Code Value Sumifformula Sumifresult
0E1 10 =SUMIF($A:$A,A1,$B:$B) 45
0E1 20 =SUMIF($A:$A,A2,$B:$B) 45
0E2 5 =SUMIF($A:$A,A3,$B:$B) 45
0E2 10 =SUMIF($A:$A,A4,$B:$B) 45

 

[ssalazarjr]

Barry,

So SUMIF & SUMIFS can not distinguish between "Numbers" and "Text"?

I'm having the same issue with 18 digit serial numbers that are imput as text. I checked using a SUMPRODUCT, and found that it could be swapping the last 3 digits to 000. So when I SUMIF on that serial number it sums all the serial numbers that have the first 15 digits matching. I get a total of $1500 instead of the $165 that it should total as. Any way to get SUMIF/S to work and not have to use SUMPRODUCT? SUMPRODUCT just seems to take up more time.