If there are no Xs in the range what result do you expect?

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
Hey Biff,

Your post got a little split up, so I'm a bit confused.
Lets say the range of interest is B3:B30
I want the Formula (which counts the consecutive blank cells) in U3.

Do I enter
=IF(B3="x","",IF(AND(B3="",B4<""),1,TEXT(0,";;;") ))
In cell U3
and do I enter
=IF(COUNTIF(B$3:B$15,"x")=0,"",IF(B4="x","",IF(OR( AND(B4="",B5<""),ROW(U4)=MAX(ROWS(B$3:B$15))),COU NTBLANK(B$3:B4)-SUM(U$3:U4),"")))

In cell U4?? Cause that's what I've done and I'm not getting any numbers,
whether I've got x's are blank cells.

Thanks for your help. You may be right, I'm just not reading the post
correctly.

Cheers,
Matt



"T. Valko" wrote:

Enter this formula in C1:
=IF(B1="x","",IF(AND(B1="",B2<""),1,TEXT(0,";;;" )))

We can reduce that to:

=IF(B1="x","",IF(AND(B1="",B2<""),1,""))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
This seems overly complicated to me but it works.

Assume the range of interest is B1:B15.

Enter this formula in C1:

=IF(B1="x","",IF(AND(B1="",B2<""),1,TEXT(0,";;;") ))

Enter this formula in C2 and copy down to C15:

=IF(COUNTIF(B$1:B$15,"x")=0,"",IF(B2="x","",IF(OR( AND(B2="",B3<""),ROW(C2)=MAX(ROWS(B$1:B$15))),COU NTBLANK(B$1:B2)-SUM(C$1:C1),"")))

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
Hey all,

I currently have a running list in columns B-S. The cells either
contain
an
'x' or is blank.

What I've looking for is a formula that will count the blank cells in
a
column, but reset once a 'x' is given. then re-start counting the
blank
cells once it occurs again.
ex.

ColumnC
x
x



<----- here it would show "4" as its been blank for 4 rows
x <----- count resets due to it not being blank.
x

<----- here it would have reset to "2" as it's currently been blank
for
2
rows


Thanks in advance!
Matt