|My spreadsheet has a column on the left with a 21 digit field and a column on the right with a matching 21 digit field and a qty. The left has 1 instance, the right has 1 or many. I'm using sumif to sum the qty for all on the right that match one on the left.|
col A col B Col C Col D
506849879780781792233 sumif(c1:c3,a1,d1:d3) 506849879780781792233 10
506849879780781794444 sumif(c1:c3,a2,d1:d3) 506849879780781792233 2
For some reason my sumif is returning 17 for b1 and b2.
It should return 12 for b1 and 5 for b2.
I tried plugging the search string directly into the second parm of sumif as a constant, but it still has problem.
So it's like it is only matching on the 1st 17 characters.
Any ideas? Could this be text vs numeric format or something??
I've used this same spreadsheet before and it works fine.