title: Alternate to sumproduct
body: <p>Does anyone know a more efficient way to write this? I seem to be having quite a bit of issues with excel giving me "not enough system resources" because I have about 30 slightly varied versions of this in my excel spread sheet.</p>
  
  <pre><code>=SUMPRODUCT((Data!B2:B1000="Human Resources")*(Data!E2:E1000&lt;&gt;"Resolved")*(Data!E2:E1000&lt;&gt;"Closed")*(Data!E2:E1000&lt;&gt;"Cancelled"))
  </code></pre>
  
  <p>I have looked into countifs but I can't seem to get that to work.</p>