title: using countsif to count items from rows if certain conditions in other columns match
body: <p>I'm trying to count instances where a value is present in column D only if certain values are present in either E,F, or G. Specifically, if an agent's extension is present in the column and there is a number 2 in any of the three columns in the row after it, it should count it. I started with this:</p>
  
  <pre><code>=COUNTIFS(D2:D392,"9123",E2:E392,"2",F2:F392,"2",G2:G392,"2")
  </code></pre>
  
  <p>But that only counts it if a 2 is the value for all three of the those columns in that row. If the value of one of the columns differs, I still want to include it in the count if a 2 is present in any of the others. </p>
  
  <p>I tried this:</p>
  
  <pre><code>=COUNTIFS(D2:D392,"9124",E2:G391,"2")
  </code></pre>
  
  <p>With the hope that it would compare the entirety of the columns/rows from E to G, and if they have a 2 and it matches the extension in question it will count it. Instead it returns the #VALUE! error.</p>
  
  <p>Any suggestions for what I might be doing wrong?</p>