I am using the following formula =COUNTIF(M3:M13,">0") but it is
ignoring cells M7 to M9. I have the same formula and data type in the
columns on both sides and they are working fine. What is wrong?