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!!
