Thread: IF statements with * character doesn't work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
flyswiftly flyswiftly is offline
external usenet poster
  
Posts: 5
Default IF statements with * character doesn't work

You could try =sum(if(right(a1:a6,5)="chips",b1:b6,0))

Horst


On Nov 8, 9:27 am, wrote:
Hi everyone,
my new problem is that the if statement doesn't like the wild
character... ie) =SUM(IF(A1:A6="chips*",B1:B6,0))

Any way around this??
Thanks

Reply With QuoteReply With Quote