ExcelBanter - Null cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Null cells (https://www.excelbanter.com/excel-programming/422823-null-cells.html)

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

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