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...
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!