I got the following text in cell A1:
GF HTG SHEET 1 (Drawing Reference- 21)
I got the following data:
| ColE | ColF |
|---|---|
| GF HTG SHEET 1 | 10 |
| GF HTG SHEET 1 | 20 |
| GF HTG SHEET 1 | 10 |
So the formula I'm trying to get to work is this one:
=SUMIF($E$2:$E$4,"*"&A1&"*",$F$2:$F$4)
It give me 0, while all instructions I've seen online point me to the approach above.
Appreciate your help.
CodePudding user response：
Try
=sumproduct(arrayformula(if(iserror(SEARCH(E2:E,$A$1)),0,1))*(F2:F))
