Does

=COUNTIF(F10:F232,"*No OMS Order*")

succeed? If it does, the entries in F10:F232 must have excessive chars
(e.g., spaces) around them.

Trace wrote:
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