Data cells ignored by formula

[[email protected]]

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?

[Bernie Deitrick]

Liz,

Those cells may actually be text - try reformatting the cells as numbers, then reenter the data in
those cells.

HTH,
Bernie
MS Excel MVP


<[email protected]> wrote in message news:[email protected]...
>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?
>