Hi folks,

I am trying to set up a formula which will count the quantity of empty cells
in Column K if there is something in the corresponding cell in Column J

These are what I have tried so far with no look

=IF(ISBLANK(J157:J2643)," ",COUNTA(H157:H2643))

and

=SUMPRODUCT(--(J157:J2643="1"),--(H157:H2643=""))

Thanks in advance for any help you can give

Dave