IF statements with * character doesn't work

[canadiangal]

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

 

[flyswiftly]

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

Horst

 

[Pete_UK]

Hi Canadian

(I've just returned from there). Try this:

=SUM(IF(LEFT(A1:A6,5)="chips",B1:B6,0))

Entered as an array fromula - CSE

Hope this helps.

Pete

 

[canadiangal]

OMG it totally works. this forum rocks!! THANKS EVERYONE!!!

 

[Pete_UK]

Thanks for feeding back.

Pete

OMG it totally works. this forum rocks!! THANKS EVERYONE!!!

 

[Dave Peterson]

=sumproduct(--(left(a1:a6,5)="chips"),b1:b6)

Non-array entered.