If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|