Count cells whitch contanes a specific part of textl

[shaggy31]

Dear,

I would like to count cells which are containing a specific part of text.

Example, i want to count cells that are containing text from Column B in it :

A	B	C (Resault)
PK555501	5555	3
PK555502	5555
PK555503	5555
PK555601	5556	1
PK555703	5557	1

<tbody>
</tbody>

I suppose it is done with COUNTIF function but I don't know how to set a Criteria.

Best regards,

Shaggy

 

[VoG]

Try in C1 copied down

=COUNTIF(A$1:A$5,"*"&B1&"*")

 

[shaggy31]

Hi VoG!

That is what I tried but it doesn't work. I tried puting ?? instead * but no luck...

Shaggy

 

[VoG]

Works here

Excel Workbook
	A	B	C
1	PK555501	5555	3
2	PK555502	5555	3
3	PK555503	5555	3
4	PK555601	5556	1
5	PK555703	5557	1
Sheet1

 

[shaggy31]

Sorry, had a typo....

It works...

Thanks!