Lookup specific alphabets in the text

[SaleemAnsari]

Hi,

Can I have the formula for looking up strings from column A and return the sum in column F:

[#2 · Accepted solution]

Try:

=SUMIF($A$1:$A$5,"*"&E1&"*",$B$1:$B$5)

[#3]

Thanks...!! :)