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

ID	Quantity
1	12
2	123
3	123
	123
	123
4	13
5	123
6	23
Result wanting
ID	Quantity
1	12
2	123
3	346
4	13
5	123
6	23

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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.