Counting occurance of empty cells

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
 
T

Tom Hutchins

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top