Countif contains a certain text string

Countif contains a certain text string

I'm trying to create an aggregate formula that counts all the rows in a column if it contains a certain text string. I can easily create the formula if it equals a certain test string, see below. 


countif("Table"."Column"='xyz')

The formula above will count the row if the cell only contains "xyz". it will not count the row if the cell contains "xyz pdq". How do I change the formula to count the rows in a column if it a cell contains a "xyz" along with any other string?