Data cells ignored by formula

L

liz.harper

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?
 
B

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
 
Top