=COUNTIF(A:A,"Closed")

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"tapley" wrote in message
...
I have a table where the words "closed" or "order" appear. I want to know
a
formula that will count how many times each word appears in a column and
give
me a figure. Is that possible and how?