Can we do Countif for partial strings in VBA

[ThrottleWorks]

Hi,
I have a file. I need to count how many times a particular string is appearing in header row.

For example. ‘Chandoo is Awesome ABC’ Chandoo is Awesome QAZ’ Chandoo is Awesome WSX’ Chandoo is Awesome EDC’.

I need to count how many times Chandoo is Awesome is appearing in the header row.
Can we do a countif by searching partial strings. Can anyone please help me in this.

 

[vletm]

A3 is Your 'criterian'
=CountIf(1:1,"*"&A3&"*")

 

[ThrottleWorks]

Hi @vletm , thanks a lot for the help. Have a nice day ahead.