Sum values till reach sum total 8 and re sum till sum total 8 again and again

[motilulla]

Hello,</SPAN></SPAN>

I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN>

Result sample...</SPAN></SPAN>

Book1
	E	F	G
1
2
3
4
5	Data	Sum	Procedure
6	5	5	Start Sum
7	1	6
8	0	6
9	0	6
10	0	6
11	1	7
12	1	8	End Sum
13	5	5	Restart Sum Again
14	0	5
15	0	5
16	0	5
17	0	5
18	0	5
19	1	6
20	1	7
21	1	8	End Sum
22	4	4	Restart Sum Again
23	1	5
24	1	6
25	2	8	End Sum
26	6	6	Restart Sum Again
27	0	6
28	2	8	End Sum
29	5	5	Restart Sum Again
30	1	6
31	0	6
32	1	7
33	0	7
34	1	8	End Sum
35	6	6	Restart Sum Again
36	0	6
37	0	6
38	3	3
39	0	3
40	0	3
41	3	3
42	1	7
43	0	7
44	0	7
45	0	7
46	0	7
47	0	7
48	1	8	End Sum
49	3	3	Restart Sum Again
50	2	5
Sheet1

Thank you all </SPAN></SPAN>

Excel 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>

 

[njimack]

Enter the following into B6, then copy down as far as required:
=A6+IF(B5>=8,0,B5)

 

[motilulla]

Enter the following into B6, then copy down as far as required:
=A6+IF(B5>=8,0,B5)

njimack, Much appreciate your formula worked as request.</SPAN></SPAN>

Have a good day</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Moti </SPAN></SPAN>