Help with countif function..

[TechnoGram]

worksheet with 3 sheets, want information from sheet 3 to show in a
countif cell on sheet 1. New to this and can not make it work
somehow. Trying to get a count on information containing the word
"clerk". Column with information on sheet 3 contains text with various
different combination containing the word clerk. Does this make a
difference? Should I not be able to put various different clerks in
the function to change the count on sheet 1? Any suggestions I keep
getting a 0 for an answer when the cell range on sheet 3 contains over
9 incidences of the word clerk.

 

[T. Valko]

Try this:

=COUNTIF(Sheet3!A1:A10,"*clerk*")

Biff