Formula help - Reducing from quantity above

[Johnr1]

Hi i am looking for some help on a formula i am trying to write. i am looking to get the remaining quantity in a cell. this is from a workload from our customer.
in a sheet we would have the following. a part number, order quantity ( can have multiple lines for different ship dates) date, total quantity on hand.
i am trying to find a formula that will help me take the order quantity from the on hand stock, (simple if only one line) but if the same part number appears above i would like to reduce the on hand quantity in line with the quantity above. i have attached a screenshot to show what i am trying to say.
Thanks in advance

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E
1
2	1234	100		2000	1900
3	1235	200		2000	1800
4	1236	150		3000	2850
5	1237	150		7000	6850
6	1234	100		2000	1800
7	1234	200		2000	1600
8	1235	100		2000	1700
9	1236	250		3000	2600
Result

Cell Formulas
Range	Formula
E2:E9	E2	=D2-SUMIFS(B$2:B2,A$2:A2,A2)

 

[Johnr1]

How about

+Fluff 1.xlsm
	A	B	C	D	E
1
2	1234	100		2000	1900
3	1235	200		2000	1800
4	1236	150		3000	2850
5	1237	150		7000	6850
6	1234	100		2000	1800
7	1234	200		2000	1600
8	1235	100		2000	1700
9	1236	250		3000	2600
Result

Cell Formulas
Range	Formula
E2:E9	E2	=D2-SUMIFS(B$2:B2,A$2:A2,A2)

Brilliant thank you for this, my head was wreacked!

 

[Fluff]

You're welcome & thanks for the feedback.