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...
It looks like it calculates correctly.
Here is SUMIF result
and here is if filter your table and calculate manually
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)
