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

T

tapley

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

Bob Phillips

=COUNTIF(A:A,"Closed")

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top