SumIF not pulling all numbers from referenced data

[tiffer86]

I have a SUMIF that is pulling a 10 digit number (6100089103) there are 4 of these numbers that are very similar, replace the last number with 4, 5 and 6. My SumIF is Summing all 4 numbers even though they are not the full number I'm wanting it to pull.

Here is my formula: This is a concatenated # sitting in the first spreadsheet referenced in cell A18, the second spreadsheet (102014 OneOk Gas Check Detail Master.xls) it's find the number in Cell E and bringing back the Value sitting in L.


=SUMIF('[102014 OneOk Gas Check Detail Master.xls]Sheet1'!$E:$E,A18,'[102014 OneOk Gas Check Detail Master.xls]Sheet1'!$L:$L)

Instead of it pulling back $75,000 it's pulling back all 4 numbers that start with 910008910

 

[tiffer86]

We thought that maybe it was truncing off the 16th digit as well, but when we added a -1 at the end of each of these numbers, it ended up pulling the data. That would mean that it has 18 digits

 

[Jonmo1]

No, by adding the -1 to the end, sumif no longer thinks it's a number and it's treated as TEXT.