ExcelBanter - string compare with wildcards

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - string compare with wildcards (https://www.excelbanter.com/excel-programming/328182-string-compare-wildcards.html)

Marcus Hoffmann

string compare with wildcards

Hi folks,

may be a stupid question, I want to use the following formula to fill a cell:

{=SUM((D3:D113="STRING")*B3:B113)}

which works fine, but accepting all kinds of "STRING*",
like: "STRING1", "STRING2222",...

is there an easy way ???

thanx in advance
marcus

All times are GMT +1. The time now is 09:50 AM.