Counting 0's

Originally Posted by E61

This is what I thought but returns 0

Then they're not zero.

Find one that you think is 0 let's say A14
In another cell, any cell enter =(A14=0)
If it says TRUE its a zero, if it says FALSE its something else (could be spaces, non ASCII characters in the same cell).