Say I have two columns of data.

DISTRICT STATUS AND DATE
10 Complete 3-2-2007
10
20 Complete 9-10-2006
20 Complete 1-1-2001

I need a function or formula that counts the number of employees who have
completed training by district. For district 10 the answer would be one. For
district 20 the answer would be two. My greatest challenge is how to count
the column that "includes" the word Complete.

Many thanks for help!