Is there a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a formula to count the number of time a word appears in a column. so:

a1 order
b1 order
c1 closed
d1 order

f1 orders 3
g1 closed 1

Is this possible and how?
 
Your references show the data in one row. Assuming the data is in
column A, then try this to count the number of times "order" appears:

=COUNTIF(A:A,"*order*")

Hope this helps.

Pete
 
Back
Top