IF statements with * character doesn't work

  • Thread starter Thread starter canadiangal
  • Start date Start date
C

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
 
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
 
=sumproduct(--(left(a1:a6,5)="chips"),b1:b6)

Non-array entered.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find last date of sold stock and sold price. 2
Wild characters in function? 3
Complicated IF statement - desperately need some help 4
sumproduct with multiple variables 8
IF Statement - compare to coloured cell 7
SUMIF "value if false" not working 2
"IF" help 2
Countif statement using dates 15

Back
Top