Formula challenge adding numbers between set numbers

[mmann1973]

I'm trying to do something I don't know if it can be done. I want to add the number of consecutive 12's until a 0 is hit (this is my data that changes frequently). The results would give the total of the consecutive 12's.
I've hit a brick wall with this. Any ideas?

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
4	DATA	0	12	12	12	0	0	0	12	12	12	12	12	0
5
6	EXPECTED
7	RESULTS	0	36	36	36	0	0	0	60	60	60	60	60	0
Sheet1

 

[Phuoc]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	DATA	0	12	12	12	0	0	0	12	12	12	12	12	12
2
3	EXPECTED
4	RESULTS	0	36	36	36	0	0	0	72	72	72	72	72	72
Sheet1

Cell Formulas
Range	Formula
B4:N4	B4	=IF(B1=0,0,IF(N(A4)>0,A4,IFERROR(SUM(OFFSET(B1,0,0,1,MATCH(0,B1:$N1,0))),SUM(B1:$N1))))

 

[mmann1973]

That formula works perfect! Thank you so much for the reply

 

[Phuoc]

You're welcome! Thanks for the feedback.