Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Scorpvin
 
Posts: n/a
Default Wildcard Character in an Array Formula


Does anybody know how to write an array formula that includes a wildcard
character such as ? or *

I'm using a simple SUM(IF) array.

=SUM(IF((C6:C25="*Wiscons*"),E6:E25,0))
Ctrl+Shift+Enter


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=472133

  #2   Report Post  
vezerid
 
Posts: n/a
Default

Scorpvin,
try the following:
=SUM(IF(ISNUMBER(FIND("Wiscons", C6:C25)), E6:E25, 0))
as array formula of course.

HTH
Kostis Vezerides

Scorpvin wrote:
Does anybody know how to write an array formula that includes a wildcard
character such as ? or *

I'm using a simple SUM(IF) array.

=SUM(IF((C6:C25="*Wiscons*"),E6:E25,0))
Ctrl+Shift+Enter


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=472133


  #3   Report Post  
Domenic
 
Posts: n/a
Default

Here's another way...

=SUMIF(C6:C25,"*Wiscons*",E6:E25)

or

=SUMIF(C6:C25,"*"&G1&"*"),E6:E25)

....where G1 contains your criterion, such as Wiscons.

Hope this helps!

In article ,
Scorpvin
wrote:

Does anybody know how to write an array formula that includes a wildcard
character such as ? or *

I'm using a simple SUM(IF) array.

=SUM(IF((C6:C25="*Wiscons*"),E6:E25,0))
Ctrl+Shift+Enter

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
Editing Array Formula [email protected] Excel Worksheet Functions 7 August 28th 05 06:46 AM
Array Formula Karen Excel Worksheet Functions 2 June 7th 05 06:49 PM
Array Formula frankybenali Excel Worksheet Functions 1 February 16th 05 07:37 PM
What instead of an array formula part 2 Reg Besseling Excel Discussion (Misc queries) 2 December 10th 04 08:35 AM
What instead of an array formula? Reg Besseling Excel Discussion (Misc queries) 3 December 6th 04 02:55 PM


All times are GMT +1. The time now is 10:26 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"