Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need flexible tool to work with flat files - Excel No Good xz Excel Discussion (Misc queries) 1 October 8th 06 12:23 AM
How to find data character width in Excel ToExcelAtExcel Excel Discussion (Misc queries) 2 September 26th 06 09:27 PM
Getting multiple IF statements to work Psycho0426 Excel Discussion (Misc queries) 15 August 18th 06 04:31 PM
Complicated work! Any idea?? craig@help Excel Worksheet Functions 0 July 19th 06 04:09 PM
Work book formulas Jessica Excel Discussion (Misc queries) 1 June 9th 05 10:51 AM


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"