<div>
Use the formula:<br />
<br />
=SUMPRODUCT((F12:F21&gt;=C8)*<wbr />(F12:F21&lt;F<wbr />8)*(G12:G2<wbr />1)*(H12:H2<wbr />1&lt;&gt;N))<br />
<br />
Cheers
</div>


<div>
I got a return &quot;False&quot;
</div>


<div>
woops - my mistake - it look &nbsp;goodv thanks
</div>


<div>
<div class="content wysiwyg-content">
This works fine:<br />
=SUMPRODUCT((F12:F21&gt;=C8)*<wbr />(F12:F21&lt;F<wbr />8)*(G12:G2<wbr />1))<br />
However, I need help in doing this:<br />
If H12:H21 the value = N then do not add to this =SUMPRODUCT((F12:F21&gt;=C8)*<wbr />(F12:F21&lt;F<wbr />8)*(G12:G2<wbr />1))<br />

</div>
</div>


This works fine:
=SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21))
However, I need help in doing this:
If H12:H21 the value = N then do not add to this =SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21))


Modify sumproduct

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.