D
DaveC
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
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