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

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,094
Office Version
  1. 2010
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
Joined
Jun 17, 2005
Messages
7,772
Enter the following into B6, then copy down as far as required:
=A6+IF(B5>=8,0,B5)
 
Solution

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,094
Office Version
  1. 2010
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>
 
Master Excel Bundle

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.

Forum statistics

Threads
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?

Disable AdBlock

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
Top