SUM Unbtil Next Number

[Jezza25]

Hi Below is 2 data fields, the first data shows current data and subsequant, I did ask a earlier question about getting it show on the individual ID's which was answered ( thanks!) what I ned is for it to add up. SO for order 3 there was actual 3 items and the quantities were 123 each, I need on a subsequant sheet for it to add up where there is a blank until it reaches order ID 4

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID[/TD]
[TD="width: 64"]Quantity[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Result wanting[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]346[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]23[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jezza25]

For 3 that should have been 369

 

[Oeldere]

with a helpcolumn (F) and after that a pivot table (I and J).

See the below result.

Book1
	D	E	F	G	H	I	J
48	number	value	help			Rijlabels	Som van value
49	1	12	1			1	12
50	2	123	2			2	123
51	3	123	3			3	369
52		123	3			4	13
53		123	3			5	123
54	4	13	4			6	23
55	5	123	5			Eindtotaal	663
56	6	23	6
Blad20

Cell Formulas
Range	Formula
F49	=IF(D49="",F48,D49)
F50	=IF(D50="",F49,D50)
F51	=IF(D51="",F50,D51)
F52	=IF(D52="",F51,D52)
F53	=IF(D53="",F52,D53)
F54	=IF(D54="",F53,D54)
F55	=IF(D55="",F54,D55)
F56	=IF(D56="",F55,D56)

 

[Jezza25]

Thanks You so much!!!!!

 

[Oeldere]

your welcome.