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
|