title: Formula for tracking Wins&Losses from a specific Year and Sports
body: <p>This is the formula I'm currently trying to use, however it only results in 0's.</p>
  
  <pre><code>=ARRAY_CONSTRAIN(ARRAYFORMULA(SUM((Log!$G$3:$G$1000 = "W") * ((Log!$J$3:$J$1000 = B2 &amp; Log!$B$3:$B$1000 = A2)))),1 ,1)
  </code></pre>
  
  <ul>
  <li>Log!$G$3:$G$1000 = Cells that are marked as W (for wins) and L (for losses).</li>
  <li>Log!$J$3:$J$1000 &amp; B2 = Which year the match was in.</li>
  <li>Log!$B$3:$B$1000 &amp; A2 = The sport.</li>
  </ul>
  
  <p>If I remove the &amp; Log!$B$3:$B$1000 = A2, the formula works just fine, but it's showing every result for every sport from every year, which isn't what I want.</p>
  
  <p>I'm trying to get it to show only the wins from a specific sport for a specified year, but I can't get any formula to work.</p>
  
  <p>Any idea?</p>
  
  <p>Edit: I should have noted, this is for google's spreadsheets.</p>