title: Excel - sumifs - condition when cell contains string
body: <p>I need little help with excel. I use SUMIF func. Here is my formula.</p>
  
  <pre><code>=SUMIFS(J:J;B:B;O4;G:G;"=ISTEXT(Intercall)")
  </code></pre>
  
  <p>I would like make a sum from values in <strong>J</strong> column, where:</p>
  
  <ul>
  <li>values in column B are same as <strong>O4</strong></li>
  <li>and where values in <strong>column G contain specific string</strong></li>
  </ul>
  
  <p>for example value in column G is Intercall - Taiwan -> thi value contains string Intercall</p>