Hey FSt1,

I'm not looking for somthing to simply count all the blank cells. I need
something that will count the blank cells in a column continuously until an
'x' apprears. Once that happens, I need the count to reset and begin from
scratch again.

ex.

ColB
x
x
(blank)
(Blank)
(blank) <---- here the count formula would give 3
(blank)
(blank) <---- here it would give 5
x
x
x
(blank) <---- here it would give 1 (it reset due to the x showing)
(blank)
(blank)
(blank)
(blank)
(blank) <---- here it would give 6

Any ideas,
Thanks
Matt


"FSt1" wrote:

hi
=countblank(A2:S50)
adjust your your range.

Regards
FSt1

"mpenkala" wrote:

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