I have a excel file using several worksheets.

On most of the worksheets the formula =COUNTIF(F10:F232, "No OMS Order")
works. However -- on 2 of the work sheets, the formula will not work.

I have this formula set up for =COUNTIF (F10:F232, "Successful") and
=COUNTIF (F10:F232, "Adjudicated") and it works great... but on this one work
sheet, as soon as I use the words "No OMS Order" I get a 0 records. Even
though there are several records that fit.

Any ideas??
Trace