Counting occurance of empty cells

  • Thread starter Thread starter DaveC
  • Start date Start date
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
 
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
 
Back
Top