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