How to group and count

[gkintl]

Hi, I would like to the formula to count if there is a "1" in the cell and stop if it encounters a "0". Again, it should start counting from 1, when it comes across a "1" in next cell.

It should look like this

A 1
B 1 2
C 0 0 <<Result
D 1 1
E 0 0
F 1
G 1
H 1 3
J 0 0

Can anyone help me with the formula? rgds,

 

[Hui]

Assuming your Data is in A1:B9
then in C2: =IF(B2=0,0,IF(B3=0,SUM($B$1:B2)-SUM($C$1:C1),""))
Copy down

 

[gkintl]

Assuming your Data is in A1:B9
then in C2: =IF(B2=0,0,IF(B3=0,SUM($B$1:B2)-SUM($C$1:C1),""))
Copy down

Hello, That works perfectly. Thank you