Thanks bob that formula does work to count occurances of text. Would a
variation of that work to count multiple words in a range (one formula)
so the total shows in one cell? Also how would I add a "not" to exclude
some words within individual cells? any ideas anyone? steveo