Find, Count, Lookup

[Dan Wilson]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (updated). I have a worksheet with 3000 Rows and several Columns containing data about music. Column A contains the Title of each song. I want to get a count of how many songs contain a given word such as Love. That word may be anywhere in the title, .and the title may be up to thirty characters I have tried using versions of Find, Countif and Lookup with no correct answers. I appreciate any help with this problem.
Thank you,
Dan Wilson...

 

[Fluff]

How about

=COUNTIFS(A:A,"*love*")

 

[Dan Wilson]

Good day Fluff, you came to the rescue again. I discovered that COUNTIF also works. In my attempts to make this work, I was missing the Asterisks around the word to search for. It is so satisfying to have expert help available.
Thank you,
Dan Wilson...

 

[Fluff]

You're welcome & thanks for the feedback.