Data cells ignored by formula

  • Thread starter Thread starter liz.harper
  • Start date Start date
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?
 
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
 
Back
Top