Counting occurance of empty cells
 

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

Counting occurance of empty cells
 

Try
=SUMPRODUCT(--(LEN(J157:J2643)0),--(LEN(K157:K2643)=0))

I used column K per your instructions, although your example formula had
column H.

Hope this helps,

Hutch

"DaveC" wrote:

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