Thread: IF statements with * character doesn't work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] canadiangal@gmail.com is offline
external usenet poster
  
Posts: 6
Default IF statements with * character doesn't work
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