Counting occurance of empty cells
Perfect thanks, worked a dream
"Tom Hutchins" wrote:
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
|