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

Array VLOOKUP lookup_Value does not increment 3
I am going crazy with Sumproduct 5
Search other sheets for numbers & color them 10
Delimma: SumIf worksheet function 0
Shed some light on this WS_Calculate macro. 3
Macro to Combine Data from Multiple Sheets with Cell References 4
Tried and true copy code lines fail me here 7
Resize a row but copy but skip columns I don't want to copy 6

Top