Thread: IF statements with * character doesn't work
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default IF statements with * character doesn't work
=sumproduct(--(left(a1:a6,5)="chips"),b1:b6)

Non-array entered.

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

--

Dave Peterson
Reply With QuoteReply With Quote