Jun 21 2018 09:06 AM
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?
Jun 21 2018 09:24 AM
It looks like it calculates correctly.
Here is SUMIF result
and here is if filter your table and calculate manually
Jun 21 2018 09:59 AM
Sorry, I attached the wrong file.
Jun 21 2018 10:11 AM - edited Jun 21 2018 10:11 AM
Jun 21 2018 10:25 AM
I'm not following on how to correct this with a soft hyphen.
Jun 21 2018 10:29 AM
Detlef, thank you. Just in case here is another workarounds https://exceljet.net/formula/count-long-numbers-without-countif
Jun 21 2018 10:44 AM
=SUMIF(data!A:A,CHAR(173)&Total!A5,data!B:B)
Jun 21 2018 12:10 PM
Thank you. Adding the CHAR(173) worked. Although not sure why but it's fixed! Thanks!