Forum Discussion
SaleemAnsari
Aug 24, 2020Copper Contributor
Lookup specific alphabets in the text
Hi,
Can I have the formula for looking up strings from column A and return the sum in column F:
- Try:
=SUMIF($A$1:$A$5,"*"&E1&"*",$B$1:$B$5)
2 Replies
- JMB17Bronze ContributorTry:
=SUMIF($A$1:$A$5,"*"&E1&"*",$B$1:$B$5)- SaleemAnsariCopper ContributorThanks...!! 🙂