Why is it that cells that seem identical are not counted by the "countif" formula in excel. I have check the formatting of the cells and they seem to be identical. I have to keep double checking my work by filtering my columns. The filter function seems to pick up the right number of cells but the countif doesn't always do this. Why is this and how do I stop it?