Formula for counting number of Columns containing a specific instring

[arkk]

Hi All

I have a data sheet in which the first row (table header) have several columns. I need to count the number of columns which has a specific instring occurrence. Is there a quick formula to do this?

eg: colum1www| column2wwwE| colwwwpot| col5 |column666

Counting the number of columns with "www" as instring in a formula (to print in a cell) = 3 (for this example)

any help is appreciated.

Many Thanks.

 

[Marc L]

Hi !

=COUNTIF(A1:E1,"*www*") …
​

 

[arkk]

Vow Marc !! Thanks very much.