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

Pete_UK wrote:
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


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