Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need flexible tool to work with flat files - Excel No Good | Excel Discussion (Misc queries) | |||
How to find data character width in Excel | Excel Discussion (Misc queries) | |||
Getting multiple IF statements to work | Excel Discussion (Misc queries) | |||
Complicated work! Any idea?? | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) |