View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcus Hoffmann Marcus Hoffmann is offline
external usenet poster
 
Posts: 1
Default 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