<div>
Holy cow. &nbsp;Pretty sad that I didn't catch that. &nbsp;But thanks for you help. &nbsp;That was an easy 500 points. &nbsp;I guess it's 1 point for the parenthesis and 499 for knowing that it was the parenthesis. &nbsp;
</div>


Holy cow.  Pretty sad that I didn't catch that.  But thanks for you help.  That was an easy 500 points.  I guess it's 1 point for the parenthesis and 499 for knowing that it was the parenthesis.  

<div>
<div class="content wysiwyg-content">
I've got a spreadsheet in which I need to count the number of names in C12:C309 where column E is not blank and column F does not have &quot;DUP&quot; in it. &nbsp;I've created a sumproduct formula below:<br />
<br />
=SUMPRODUCT(C12:C309&lt;&gt;&quot;&quot;)*<wbr />(E12:E309&lt;<wbr />&gt;&quot;&quot;)*(F12:<wbr />F309&lt;&gt;&quot;DUP<wbr />&quot;)<br />
<br />
This formula should work perfectly in theory, and in fact does do what I want on a &quot;normal&quot; spreadsheet with static values in columns C, E and F. &nbsp;But in my &quot;real&quot; spreadsheet, the values in Columns C, E and F are pulling from another linked spreadsheet and only &quot;appear&quot; blank or empty through the use of an IF statement (=IF&lt;linkfield&gt;=&quot;&quot;,&quot;&quot;,&lt;lin<wbr />kfield&gt;). In other words, all rows 12 to 309 have an IF statement in them.<br />
<br />
So somehow I need to have the SUMPRODUCT fn NOT count the row if the calculated value of each field is blank. &nbsp;Makes sense?
</div>
</div>


I've got a spreadsheet in which I need to count the number of names in C12:C309 where column E is not blank and column F does not have "DUP" in it.  I've created a sumproduct formula below:

=SUMPRODUCT(C12:C309<>"")*(E12:E309<>"")*(F12:F309<>"DUP")

This formula should work perfectly in theory, and in fact does do what I want on a "normal" spreadsheet with static values in columns C, E and F.  But in my "real" spreadsheet, the values in Columns C, E and F are pulling from another linked spreadsheet and only "appear" blank or empty through the use of an IF statement (=IF<linkfield>="","",<linkfield>). In other words, all rows 12 to 309 have an IF statement in them.

So somehow I need to have the SUMPRODUCT fn NOT count the row if the calculated value of each field is blank.  Makes sense?

SUMPRODUCT test for blank cells

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