Thread: Wildcard Character in an Array Formula
View Single Post
  #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

Reply With QuoteReply With Quote