How to search for text, that is only part of a cell

Hi,
I have a .ods from Google Forms, and i have a lot of responses. I want to do a =count but the searched text sometimes just a part of the cell’s data.
How can i search in this way?