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

#### motilulla

##### Well-known Member
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
EFG
1
2
3
4
5DataSumProcedure
655Start Sum
716
806
906
1006
1117
1218End Sum
1355Restart Sum Again
1405
1505
1605
1705
1805
1916
2017
2118End Sum
2244Restart Sum Again
2315
2416
2528End Sum
2666Restart Sum Again
2706
2828End Sum
2955Restart Sum Again
3016
3106
3217
3307
3418End Sum
3566Restart Sum Again
3606
3706
3833
3903
4003
4133
4217
4307
4407
4507
4607
4707
4818End Sum
4933Restart Sum Again
5025
Sheet1

Thank you all </SPAN></SPAN>

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

Last edited:

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### njimack

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

#### motilulla

##### Well-known Member
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>

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,532
Messages
5,854,288
Members
431,636
Latest member
shabbas313

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back