 <p>As written your formula will always return zero because the last two conditions are mutually exclusive - did you mean those last two to be &lt;> rather than = (or did you refer to the wrong columns)?</p> <p>In any case I can see from the use of whole columns that you must be using <code>Excel 2007</code> or later (your current formula would give an error otherwise) in which case <code>COUNTIFS</code> will be much faster, i.e. assuming the last two conditions should be adjusted as I suggested try this version:</p> <p><code>=COUNTIFS(Sheet1!J:J,Sheet2!A2,Sheet1!G:G,"Windows XP",Sheet1!B:B,"Desktop",Sheet1!M:M,"&lt;&gt;Refresh &gt;=Q2 2014",Sheet1!M:M,"&lt;&gt;Release 2013",Sheet1!M:M,"&lt;&gt;Release 2014",Sheet1!M:M,"&lt;&gt;N/A NVM",Sheet1!M:M,"&lt;&gt;No",Sheet1!M:M,"&lt;&gt;N/A")</code></p> <p>If you <strong>do</strong> need to use SUMPRODUCT then restrict the ranges rather than using whole columns</p>