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

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

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