Forum Discussion
Solved
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
- Try:
=SUMIF($A$1:$A$5,"*"&E1&"*",$B$1:$B$5)- Thanks...!! 🙂