SUMIF Formula pulling results other than exact match

[jvelazquez89]

I used and Index Match formula and received a#N/A error. I then switched to a Sumif formula and should have gotten a $0 but instead got a value. When looking at my data, the sumif formula is pulling a close match instead of an exact match. For instance, when looking up a transaction id of 1234567 between two columns the sumif will give me the value of 1234569 which ends in a different number. I have multiple transaction ids that i need summed so index match wont work since it just pulls the first occurance, but since some ID's are similar i do not want to use Sumif since an exact match only is not my result. Any advice other than Sumproduct which when using on 100K rows pretty much blows up my computer?

 

[Joe4]

Welcome to the Board!

Are these transaction ID strictly numeric, or are the alphanumeric?
If they are numeric, exactly how long are they? Excel can only remember so many significant digits for numbers. So depending on the actual length of these values, you could be running into that issue (so, what is the length of these values)?

It might be helpful if you can post a small data sample set, that is not working, along with the exact formula you are using.