Adjusting Countif formula to partially match cell

[Corleone]

Hi
I am using the following formula
=COUNTIFS('All Milestone Report'!$U$2:$U$20000,AE8,'All Milestone Report'!$W$2:$W$20000,">0")
however i need to modify it some that it picks up any instance where the text in AE8 occurs in one of the cells in Column U
the formula below works for exact matches but i want to pick up items where for example cell AE8 = "149268IS" and it recognises any entry in column U that contains that text even though its likely to be part of the cell content (E,G "149268IS ADS1)

I tried placing an asterix before,AE8 as that seems to work for SUMIF but it doesn't accept that

Cheers

 

[Fluff]

Try it like

=COUNTIFS('All Milestone Report'!$U$2:$U$20000,"*"&AE8&"*",'All Milestone Report'!$W$2:$W$20000,">0")

 

[Corleone]

Mr Fluff Delivers Again

 

[Fluff]

Glad to help & thanks for the feedback.