title: Excel: SUMIFS to sum values adjacent to text strings contained within a text string
body: <p>I'm hoping to sum numeric values with a multi-conditional, multi-array function that integrates wildcard searches into a reference formula. </p>
  
  <p>My data is structured as in the excerpt at <a href="http://bit.ly/Xv8tHP" rel="nofollow noreferrer">http://bit.ly/Xv8tHP</a></p>
  
  <p><img src="https://i.stack.imgur.com/jsK7y.png" alt="enter image description here"></p>
  
  <p>My objective for the formula in C2 is to:</p>
  
  <ul>
  <li>Sum values from $C$3:$C$24 in the "Price" column,</li>
  <li>for the rows in which $A$3:$A$24 = A2 ["New York" in this example], and</li>
  <li>for the rows in which the full text string in $B$3:$B$24 is found within B2 ["Digital TV" and "Basic" in this example].</li>
  </ul>
  
  <p>The result to output to C2 in this example would be $80.95 from C24 + $38.99 from C3 = $119.94.</p>
  
  <p>For the first condition, the following formula snippet works:
  =SUMIFS($C$3:$C$24,$A$3:$A$24,"="&amp;A2,[...]</p>
  
  <p>But I'm stumped when it comes to integrating the second condition, whether by using ISERROR(SEARCH[...])=FALSE, or INDEX, or another reference function. The 'contained by' part of the condition seems troublesome.</p>
  
  <p>Does anyone have a suggestion?</p>
  
  <p>Many thanks!</p>