<div>
GREAT! THANK YOU! I was making it way too complicated....
</div>


<div>
<div class="content wysiwyg-content">
Is there a way in include a list of values in a formula, to EXCLUDE from it counting. For example, &nbsp;I need to EXLUDE from the counts both BLANK spaces and &quot;NOCODE&quot; IN COLUMN B and am struggling with an effective way to do this.<br />
<br />
=SUMPRODUCT((MFDATA!$D$2:$<wbr />D$5000=$A2<wbr />5)*(MFDATA<wbr />!$L$2:$L$5<wbr />000=&quot;N&quot;)*(<wbr />MFDATA!$C$<wbr />2:$C$5000&lt;<wbr />&gt;&quot;&quot;))-SUMP<wbr />RODUCT((MF<wbr />DATA!$M$2:<wbr />$M$5000=$A<wbr />25)*(MFDAT<wbr />A!$L$2:$L$<wbr />5000=&quot;N&quot;)*<wbr />(MFDATA!$C<wbr />$2:$C$5000<wbr />&lt;&gt;&quot;&quot;))
</div>
</div>


Is there a way in include a list of values in a formula, to EXCLUDE from it counting. For example,  I need to EXLUDE from the counts both BLANK spaces and "NOCODE" IN COLUMN B and am struggling with an effective way to do this.

=SUMPRODUCT((MFDATA!$D$2:$D$5000=$A25)*(MFDATA!$L$2:$L$5000="N")*(MFDATA!$C$2:$C$5000<>""))-SUMPRODUCT((MFDATA!$M$2:$M$5000=$A25)*(MFDATA!$L$2:$L$5000="N")*(MFDATA!$C$2:$C$5000<>""))

GREAT! THANK YOU! I was making it way too complicated....

I need to update a formula

Is there a way in include a list of values in a formula, to EXCLUDE from it counting. For example,  I need to EXLUDE from the counts both BLANK spaces and &quot;NOCODE&quot; IN COLUMN B and am struggling with an effective way to do this.

=SUMPRODUCT((MFDATA!$D$2:$D$5000=$A25)*(MFDATA!$L$2:$L$5000=&quot;N&quot;)*(MFDATA!$C$2:$C$5000&lt;&gt;&quot;&quot;))-SUMPRODUCT((MFDATA!$M$2:$M$5000=$A25)*(MFDATA!$L$2:$L$5000=&quot;N&quot;)*(MFDATA!$C$2:$C$5000&lt;&gt;&quot;&quot;))

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