SUMIF Formula populating wrong data

[D M]

My SUMIF Formula works in my entire workbook except there are certain cells where it's pulling the wrong data.  Attached is a sample subset.  I've tried ensuring the cells are in the same format, etc.  I use SUMIF extensively so I'm not sure what the issue is.  Any thoughts?  

[#2]

It looks like it calculates correctly.

Here is SUMIF result

and here is if filter your table and calculate manually

[#3]

Sorry, I attached the wrong file.  

[#4]

D M,

read this and praise Lori :)

Lori's solution for the COUNTIF bug

[#5]

I'm not following on how to correct this with a soft hyphen.  

[#6]

Detlef, thank you. Just in case here is another workarounds https://exceljet.net/formula/count-long-numbers-without-countif

[#7]

=SUMIF(data!A:A,CHAR(173)&Total!A5,data!B:B)

[#8]

Thank you.  Adding the CHAR(173) worked.  Although not sure why but it's fixed!  Thanks!