DogGoneGood
New Member
- Joined
- Nov 29, 2010
- Messages
- 5
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
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