<div>
Do you need to check the entire B column or just a specific cell? You could easily use the if() formula to test if a cell or range of cells is blank, and either have two separate Sumproduct() equations, or have the if() return a 0 that is added to the existing equation.
</div>


Do you need to check the entire B column or just a specific cell? You could easily use the if() formula to test if a cell or range of cells is blank, and either have two separate Sumproduct() equations, or have the if() return a 0 that is added to the existing equation.

<div>
<div class="content wysiwyg-content">
OK, here is a softball for someone...<br />
<br />
I need the following formula to EXCLUDE column B from the counts if Column B is blank. Column B contains text.<br />
<br />
=SUMPRODUCT((MFDATA!$C$2:$<wbr />C$5000=MFI<wbr />NFO!A6)*(M<wbr />FDATA!$H$2<wbr />:H$5000+MF<wbr />DATA!$I$2:<wbr />I$5000+MFD<wbr />ATA!$N$2:$<wbr />N$5000=0)*<wbr />(MFDATA!$K<wbr />$2:$K$5000<wbr />=&quot;N&quot;))
</div>
</div>


OK, here is a softball for someone...

I need the following formula to EXCLUDE column B from the counts if Column B is blank. Column B contains text.

=SUMPRODUCT((MFDATA!$C$2:$C$5000=MFINFO!A6)*(MFDATA!$H$2:H$5000+MFDATA!$I$2:I$5000+MFDATA!$N$2:$N$5000=0)*(MFDATA!$K$2:$K$5000="N"))

I need an updated excel formula

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