Wildcard Character in an Array Formula

  • Thread starter Thread starter Scorpvin
  • Start date Start date
S

Scorpvin

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

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

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

HTH
Kostis Vezerides
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
Using wildcards in Array formulae 2
Wildcard characters in countif array formulas 4
hlookup in array 2
How can I use the * wildcard in an array formula 4
Sumproduct and Array Formula 3
3d array formulas 2
Issue Adding an Array Formula to a cell at Runtime. 4

Back
Top