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

"bijan" wrote:

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