I’ve been given an excel file that I’d like to use the countif function for. When I run the formula for column F, the result comes up as “0” – even though every cell in column F has a number in it that should provide a result in the countif cell.

However, when I go into each cell in column F and type the number already displayed in the cell, results start appearing for the countif function. It’s like the formula isn’t reading the numbers in the cell as the spreadsheet was sent to me.

Anybody know why this happens? It’s stupid to go through 900 cells typing each number already in the cell to get the countif function to work.