counting groups of blank cells

  • Thread starter Thread starter mpenkala
  • Start date Start date
M

mpenkala

Hey,

Need some help with a simple problem. I currently have 3 columns. In
column A, there is numbers ranging from 0 to 10.

Depending on the number, I will either get a "x" in Column B or Column C.

What I'm trying to do in Column D count the string of blank cells in Column
C.
So...

A B C D
1 x
7 x
5 x 2
3 x
3 x
2 x
8 x
0 x
9 x
5 x 4

Any help would be great :)

Thanks,
Matt
 
Try this...

Assuming the data starts on row 1.

Entered in **D2**:

=IF(AND(C2="x",C1=""),COUNTBLANK(C$1:C1)-SUM(D$1:D1),"")

Copy down as needed.
 
Thanks T.Valko,

worked perfect.

Cheers,
Matt


T. Valko said:
Try this...

Assuming the data starts on row 1.

Entered in **D2**:

=IF(AND(C2="x",C1=""),COUNTBLANK(C$1:C1)-SUM(D$1:D1),"")

Copy down as needed.
Click to expand...
 
Back
Top