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

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

IF statements with * character doesn't work
 

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

IF statements with * character doesn't work
 

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

IF statements with * character doesn't work
 

Thanks for feeding back.

Pete

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

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