countifs help

[Barto]

Hi,

I'm trying to do a "countifs" formula that has to meet a few criteria and there is one criteria I'm not sure how to write (the other criteria are straight forward)

the criteria is if I find certain text in a cell but the text could be anywhere in the cell... at the start at the end in the middle..

For example if I'm looking for "VEA 01" how do I get it to count it if is appears somewhere in the cell

Example cell 1 = "VEA 05 VEA 03 VEA 01"
Example cell 2 = "VEA 01 VEA 06 VEA 04"
Example cell 3 = "VEA 05 VEA 01 VEA 04"
Example cell 4 = "VEA 05 VEA 01"
Example cell 5 = "VEA 01"

In all of the above examples VEA 01 has appeared somewhere in the cell so I want it counted..

 

[Barto]

Think I got it sorted thanks..... have corrupt data initially