Null cells

B

bijan

Hi Experts,
How can I define Null cells in first part of SUMPRODUCT function:

With ActiveSheet
Lrow = .Range("A" & .Rows.Count).End(xlUp).Row
.Range("C25:C" & Lrow).Formula = _
"=SUMPRODUCT((TEST!$B$10:$B$20000 IS
Null)*(TEST!$E$10:$E$20000=""NO"")*(SCH_COM!$G$10:$G$20000=""Yes"")*(TEST!$J$10:$J$20000))"
End With
Thanks in advance
Bijan
 
M

Mike H

Hi,

Simply double up on the quotes as in other parts of the formula

..Range("C25:C" & lrow).Formula = "=SUMPRODUCT((TEST!$B$10:$B$20000
="""")*(TEST!$E$10:$E$20000=""NO"")*(SCH_COM!$G$10:$G$20000=""Yes"")*(TEST!$J$10:$J$20000))"

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search other sheets for numbers & color them 10
Shed some light on this WS_Calculate macro. 3
Tried and true copy code lines fail me here 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Resize a row but copy but skip columns I don't want to copy 6
Array code only works on selected sheet 14
VBA CreateNames (ignores last 5 rows?) 6
Open four Wbooks, copy four columns from each to Master Wbook 16

Top