Sum a column until a specific number is reached

[DocDeb]

I would like to Sum a column until 50 is reached. Continue summing the same column again with the remainder from the previous cell if over 50 until 50 is reached again and keep going.
In an adjacent column insert consecutive numbers for each sum of 50.

 

[DocDeb]

I don't know if i got it right. Isn't the result you need the vol column?

If so, would this work? Just check column E (vol) (the others are just quick helper column to get to that result which can be compacted into a one cell formula)

Book1
	A	B	C	D	E
1	Size	Sum	Mod 50	Aux	Vol
2
3	50	50	0	1	Vol 1
4	2	52	2	0
5	49	101	1	1	Vol 2
6	102	203	3	2	Vol 3 to 4
7	45.6	248.6	48.6	0
8	150	398.6	48.6	3	Vol 5 to 7
9	45	443.6	43.6	1	Vol 8
10	15	458.6	8.6	1	Vol 9
Sheet1 (2)

Cell Formulas
Range	Formula
B3:B10	B3	=SUM($A$3:A3)
C3:C10	C3	=MOD(SUM($A$3:A3), 50)
D3	D3	=(B3-C3)/50
E3:E10	E3	=IF(D3, "Vol "&SUM($D$2:D2) + 1 & IF(D3>1, " to "&SUM($D$2:D2)+D3, ""), "")
D4:D10	D4	=(B4-C4)/50-SUM($D$3:D3)

This looked really cool! I like the Vols being displayed as combined

Thank you.
Although, this is still not totally there.

0.5	0.5	0.5 (Good)
55	55.5	5.5 (Good)
101	106.5	56.5 (Good)
75	81.5	31.5 (This should be 81.5)

But, in Column C, I think I will just use =IF(B2-50<0,B2,B2-50) I wanted a more dynamic calculation, but this should do since Column B is working (as far as I can tell).

Seriously! What an idiot I am for not seeing what you did was correct!

 

[DocDeb]

I don't know if i got it right. Isn't the result you need the vol column?

If so, would this work? Just check column E (vol) (the others are just quick helper column to get to that result which can be compacted into a one cell formula)

Book1
	A	B	C	D	E
1	Size	Sum	Mod 50	Aux	Vol
2
3	50	50	0	1	Vol 1
4	2	52	2	0
5	49	101	1	1	Vol 2
6	102	203	3	2	Vol 3 to 4
7	45.6	248.6	48.6	0
8	150	398.6	48.6	3	Vol 5 to 7
9	45	443.6	43.6	1	Vol 8
10	15	458.6	8.6	1	Vol 9
Sheet1 (2)

Cell Formulas
Range	Formula
B3:B10	B3	=SUM($A$3:A3)
C3:C10	C3	=MOD(SUM($A$3:A3), 50)
D3	D3	=(B3-C3)/50
E3:E10	E3	=IF(D3, "Vol "&SUM($D$2:D2) + 1 & IF(D3>1, " to "&SUM($D$2:D2)+D3, ""), "")
D4:D10	D4	=(B4-C4)/50-SUM($D$3:D3)

I was looking for a bit of help with counting the Vols, and I see where you are going with this solution.
Column B doesn't start over after 50 but is use to count the Vols in Column D with Vols displayed in Column E. I like the Vols being displayed as combined e.g."Vol 3 to 4".

 

[DocDeb]

Kaper and felixstraube Thank you for your solutions! They both worked! I appreciate your patience, diligence and expertice! ​

 

[felixstraube]

Glad we could help. Thanks for the feedback.

 

[Kaper]

You are welcome,

(indeed this thread was a good patience test )