Counting Text in cells

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

Guest

I would like to create a formula in Excel that will count the number of times a word appears in cells under a specific column
Such as Column D. D1 contains the column name Timeframe. Under D1 certain words appear including Thanksgiving week. On the last row in that column I would like to know the number of times Thanksgiving week appears in that column

Thanks for all your help.
 
countif should work for this:

countif(d2:d9999,"*thanksgiving week*")


Tiger said:
I would like to create a formula in Excel that will count the number of
Click to expand...
times a word appears in cells under a specific column.
Such as Column D. D1 contains the column name Timeframe. Under D1
Click to expand...
certain words appear including Thanksgiving week. On the last row in that
column I would like to know the number of times Thanksgiving week appears in
that column.
 
Back
Top