I want a box with the total number of times ORDER appears!

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?

=COUNTIF(A:A,"Closed")

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"tapley" <[email protected]> wrote in message
news:[email protected]...
> 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?

You also have replies at your other post.

Pete

=COUNTIF(A:A,"open")&" Open, "&COUNTIF(A:A,"closed")&" Closed"

Vaya con Dios,
Chuck, CABGx3



"tapley" wrote:

> 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?