Counting Text in cells

[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.

 

[Dave R.]

countif should work for this:

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

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.

 

[Guest]

Thank you Dave R. for your help

Cheers!