Forum Discussion
SUMIF Formula populating wrong data
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...
Sorry, I attached the wrong file.
Detlef, thank you. Just in case here is another workarounds https://exceljet.net/formula/count-long-numbers-without-countif
I'm not following on how to correct this with a soft hyphen.
=SUMIF(data!A:A,CHAR(173)&Total!A5,data!B:B)
Thank you. Adding the CHAR(173) worked. Although not sure why but it's fixed! Thanks!
