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?

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

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

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

You also have replies at your other post.

Pete

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

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