Count rows that contains partial specific text

Count rows that contains partial specific text :

To count the number of rows that contains partial specific text.

Use formula =countif(range,"*"&text&"*"). 

Please note : 1) It is for to count non-case sensitive text. 2) It count the number of rows that consist specific text , not the occurrence of text. Let say, if text contains two times in a row then it count one instead of two.

Thank you!!