Prev: Algebraic Functions
Next: Correct a Cell
From: DaveC on 27 May 2010 15:53
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
 | 
Pages: 1
Prev: Algebraic Functions
Next: Correct a Cell